DBA Data[Home] [Help]

APPS.OZF_COPY_OFFER_PVT dependencies on FND_GLOBAL

Line 1251: ,FND_GLOBAL.user_id

1247: ,l_line_detail.start_date_active
1248: ,l_line_detail.end_date_active
1249: ,l_line_detail.uom_code
1250: ,SYSDATE
1251: ,FND_GLOBAL.user_id
1252: ,SYSDATE
1253: ,FND_GLOBAL.user_id
1254: ,FND_GLOBAL.conc_login_id
1255: ,1

Line 1253: ,FND_GLOBAL.user_id

1249: ,l_line_detail.uom_code
1250: ,SYSDATE
1251: ,FND_GLOBAL.user_id
1252: ,SYSDATE
1253: ,FND_GLOBAL.user_id
1254: ,FND_GLOBAL.conc_login_id
1255: ,1
1256: ,p_offer_id);
1257: END copy_discount_line;

Line 1254: ,FND_GLOBAL.conc_login_id

1250: ,SYSDATE
1251: ,FND_GLOBAL.user_id
1252: ,SYSDATE
1253: ,FND_GLOBAL.user_id
1254: ,FND_GLOBAL.conc_login_id
1255: ,1
1256: ,p_offer_id);
1257: END copy_discount_line;
1258:

Line 1329: ,FND_GLOBAL.user_id

1325: ,l_product_detail.end_date_active
1326: ,p_new_line_id
1327: ,p_offer_id
1328: ,SYSDATE
1329: ,FND_GLOBAL.user_id
1330: ,SYSDATE
1331: ,FND_GLOBAL.user_id
1332: ,FND_GLOBAL.conc_login_id
1333: ,1

Line 1331: ,FND_GLOBAL.user_id

1327: ,p_offer_id
1328: ,SYSDATE
1329: ,FND_GLOBAL.user_id
1330: ,SYSDATE
1331: ,FND_GLOBAL.user_id
1332: ,FND_GLOBAL.conc_login_id
1333: ,1
1334: ,p_parent_prod_id);
1335: END copy_discount_prod;

Line 1332: ,FND_GLOBAL.conc_login_id

1328: ,SYSDATE
1329: ,FND_GLOBAL.user_id
1330: ,SYSDATE
1331: ,FND_GLOBAL.user_id
1332: ,FND_GLOBAL.conc_login_id
1333: ,1
1334: ,p_parent_prod_id);
1335: END copy_discount_prod;
1336:

Line 1520: ,FND_GLOBAL.user_id

1516: ,active_flag
1517: ,object_version_number)
1518: VALUES(l_new_qual_id
1519: ,SYSDATE
1520: ,FND_GLOBAL.user_id
1521: ,SYSDATE
1522: ,FND_GLOBAL.user_id
1523: ,FND_GLOBAL.conc_login_id
1524: ,l_market_elig.qualifier_grouping_no

Line 1522: ,FND_GLOBAL.user_id

1518: VALUES(l_new_qual_id
1519: ,SYSDATE
1520: ,FND_GLOBAL.user_id
1521: ,SYSDATE
1522: ,FND_GLOBAL.user_id
1523: ,FND_GLOBAL.conc_login_id
1524: ,l_market_elig.qualifier_grouping_no
1525: ,l_market_elig.qualifier_context
1526: ,l_market_elig.qualifier_attribute

Line 1523: ,FND_GLOBAL.conc_login_id

1519: ,SYSDATE
1520: ,FND_GLOBAL.user_id
1521: ,SYSDATE
1522: ,FND_GLOBAL.user_id
1523: ,FND_GLOBAL.conc_login_id
1524: ,l_market_elig.qualifier_grouping_no
1525: ,l_market_elig.qualifier_context
1526: ,l_market_elig.qualifier_attribute
1527: ,l_market_elig.qualifier_attr_value

Line 2030: ,FND_GLOBAL.user_id

2026: ,l_offer_rec.qualifier_id
2027: ,l_offer_rec.qualifier_type
2028: ,DECODE(l_offer_rec.custom_setup_id, 101, 'Y', 108, 'Y', 'N')--l_offer_rec.budget_offer_yn
2029: ,SYSDATE
2030: ,FND_GLOBAL.user_id
2031: ,FND_GLOBAL.user_id
2032: ,SYSDATE
2033: ,FND_GLOBAL.conc_login_id
2034: ,NULL

Line 2031: ,FND_GLOBAL.user_id

2027: ,l_offer_rec.qualifier_type
2028: ,DECODE(l_offer_rec.custom_setup_id, 101, 'Y', 108, 'Y', 'N')--l_offer_rec.budget_offer_yn
2029: ,SYSDATE
2030: ,FND_GLOBAL.user_id
2031: ,FND_GLOBAL.user_id
2032: ,SYSDATE
2033: ,FND_GLOBAL.conc_login_id
2034: ,NULL
2035: ,l_offer_rec.break_type

Line 2033: ,FND_GLOBAL.conc_login_id

2029: ,SYSDATE
2030: ,FND_GLOBAL.user_id
2031: ,FND_GLOBAL.user_id
2032: ,SYSDATE
2033: ,FND_GLOBAL.conc_login_id
2034: ,NULL
2035: ,l_offer_rec.break_type
2036: ,l_offer_rec.volume_offer_type
2037: ,l_offer_rec.confidential_flag

Line 2088: ,FND_GLOBAL.user_id

2084: ,owner_flag)
2085: VALUES
2086: (ams_act_access_s.NEXTVAL
2087: ,SYSDATE
2088: ,FND_GLOBAL.user_id
2089: ,SYSDATE
2090: ,FND_GLOBAL.user_id
2091: ,l_offer_rec.qp_list_header_id
2092: ,'OFFR'

Line 2090: ,FND_GLOBAL.user_id

2086: (ams_act_access_s.NEXTVAL
2087: ,SYSDATE
2088: ,FND_GLOBAL.user_id
2089: ,SYSDATE
2090: ,FND_GLOBAL.user_id
2091: ,l_offer_rec.qp_list_header_id
2092: ,'OFFR'
2093: ,l_offer_rec.owner_id
2094: ,'USER'

Line 2095: ,FND_GLOBAL.conc_login_id

2091: ,l_offer_rec.qp_list_header_id
2092: ,'OFFR'
2093: ,l_offer_rec.owner_id
2094: ,'USER'
2095: ,FND_GLOBAL.conc_login_id
2096: ,1
2097: ,SYSDATE
2098: ,'Y' --NULL nepanda For Bug 10385923. Setting Admin Flag for OWNER to Y, as it should be 'Y' by default
2099: ,NULL

Line 2130: ,FND_GLOBAL.conc_login_id

2126: ,l_offer_rec.offer_code
2127: ,NULL
2128: ,SYSDATE
2129: ,SYSDATE
2130: ,FND_GLOBAL.conc_login_id
2131: ,FND_GLOBAL.user_id
2132: ,FND_GLOBAL.user_id);
2133: -- end create access in ams_act_access_denorm
2134:

Line 2131: ,FND_GLOBAL.user_id

2127: ,NULL
2128: ,SYSDATE
2129: ,SYSDATE
2130: ,FND_GLOBAL.conc_login_id
2131: ,FND_GLOBAL.user_id
2132: ,FND_GLOBAL.user_id);
2133: -- end create access in ams_act_access_denorm
2134:
2135: -- create access for default team

Line 2132: ,FND_GLOBAL.user_id);

2128: ,SYSDATE
2129: ,SYSDATE
2130: ,FND_GLOBAL.conc_login_id
2131: ,FND_GLOBAL.user_id
2132: ,FND_GLOBAL.user_id);
2133: -- end create access in ams_act_access_denorm
2134:
2135: -- create access for default team
2136: l_default_team := FND_PROFILE.value('OZF_DEFAULT_OFFER_TEAM');

Line 2167: ,FND_GLOBAL.user_id

2163: ,owner_flag)
2164: VALUES
2165: (ams_act_access_s.NEXTVAL
2166: ,SYSDATE
2167: ,FND_GLOBAL.user_id
2168: ,SYSDATE
2169: ,FND_GLOBAL.user_id
2170: ,l_offer_rec.qp_list_header_id
2171: ,'OFFR'

Line 2169: ,FND_GLOBAL.user_id

2165: (ams_act_access_s.NEXTVAL
2166: ,SYSDATE
2167: ,FND_GLOBAL.user_id
2168: ,SYSDATE
2169: ,FND_GLOBAL.user_id
2170: ,l_offer_rec.qp_list_header_id
2171: ,'OFFR'
2172: ,l_default_team
2173: ,'GROUP'

Line 2174: ,FND_GLOBAL.conc_login_id

2170: ,l_offer_rec.qp_list_header_id
2171: ,'OFFR'
2172: ,l_default_team
2173: ,'GROUP'
2174: ,FND_GLOBAL.conc_login_id
2175: ,1
2176: ,SYSDATE
2177: ,l_admin_flag --nepanda For Bug 10385923. Updating the admin flag for the default group with the admin flag of the offer from which this offer is getting copied
2178: ,NULL

Line 2268: ,FND_GLOBAL.user_id

2264: ,total_attr_count)
2265: VALUES
2266: (l_new_limit_id
2267: ,SYSDATE
2268: ,FND_GLOBAL.user_id
2269: ,SYSDATE
2270: ,FND_GLOBAL.user_id
2271: ,FND_GLOBAL.conc_login_id
2272: ,l_line_limits.program_application_id

Line 2270: ,FND_GLOBAL.user_id

2266: (l_new_limit_id
2267: ,SYSDATE
2268: ,FND_GLOBAL.user_id
2269: ,SYSDATE
2270: ,FND_GLOBAL.user_id
2271: ,FND_GLOBAL.conc_login_id
2272: ,l_line_limits.program_application_id
2273: ,l_line_limits.program_id
2274: ,SYSDATE

Line 2271: ,FND_GLOBAL.conc_login_id

2267: ,SYSDATE
2268: ,FND_GLOBAL.user_id
2269: ,SYSDATE
2270: ,FND_GLOBAL.user_id
2271: ,FND_GLOBAL.conc_login_id
2272: ,l_line_limits.program_application_id
2273: ,l_line_limits.program_id
2274: ,SYSDATE
2275: ,NULL

Line 2391: ,FND_GLOBAL.user_id

2387: ,total_attr_count)
2388: VALUES
2389: (l_new_limit_id
2390: ,SYSDATE
2391: ,FND_GLOBAL.user_id
2392: ,SYSDATE
2393: ,FND_GLOBAL.user_id
2394: ,FND_GLOBAL.conc_login_id
2395: ,l_line_limits.program_application_id

Line 2393: ,FND_GLOBAL.user_id

2389: (l_new_limit_id
2390: ,SYSDATE
2391: ,FND_GLOBAL.user_id
2392: ,SYSDATE
2393: ,FND_GLOBAL.user_id
2394: ,FND_GLOBAL.conc_login_id
2395: ,l_line_limits.program_application_id
2396: ,l_line_limits.program_id
2397: ,SYSDATE

Line 2394: ,FND_GLOBAL.conc_login_id

2390: ,SYSDATE
2391: ,FND_GLOBAL.user_id
2392: ,SYSDATE
2393: ,FND_GLOBAL.user_id
2394: ,FND_GLOBAL.conc_login_id
2395: ,l_line_limits.program_application_id
2396: ,l_line_limits.program_id
2397: ,SYSDATE
2398: ,NULL

Line 2671: l_contact_point_rec.last_updated_by := FND_GLOBAL.user_id;

2667: IF AMS_CpyUtility_PVT.is_copy_attribute ('CPNT', p_attributes_table) = FND_API.G_TRUE THEN
2668: FOR l_contact_point IN c_contact_point LOOP
2669: l_contact_point_rec.contact_point_id := Fnd_Api.g_miss_num;
2670: l_contact_point_rec.last_update_date := SYSDATE;
2671: l_contact_point_rec.last_updated_by := FND_GLOBAL.user_id;
2672: l_contact_point_rec.creation_date := SYSDATE;
2673: l_contact_point_rec.created_by := FND_GLOBAL.user_id;
2674: l_contact_point_rec.last_update_login := FND_GLOBAL.conc_login_id;
2675: l_contact_point_rec.object_version_number := 1;

Line 2673: l_contact_point_rec.created_by := FND_GLOBAL.user_id;

2669: l_contact_point_rec.contact_point_id := Fnd_Api.g_miss_num;
2670: l_contact_point_rec.last_update_date := SYSDATE;
2671: l_contact_point_rec.last_updated_by := FND_GLOBAL.user_id;
2672: l_contact_point_rec.creation_date := SYSDATE;
2673: l_contact_point_rec.created_by := FND_GLOBAL.user_id;
2674: l_contact_point_rec.last_update_login := FND_GLOBAL.conc_login_id;
2675: l_contact_point_rec.object_version_number := 1;
2676: l_contact_point_rec.arc_contact_used_by := 'OFFR';
2677: l_contact_point_rec.act_contact_used_by_id := l_offer_rec.qp_list_header_id;

Line 2674: l_contact_point_rec.last_update_login := FND_GLOBAL.conc_login_id;

2670: l_contact_point_rec.last_update_date := SYSDATE;
2671: l_contact_point_rec.last_updated_by := FND_GLOBAL.user_id;
2672: l_contact_point_rec.creation_date := SYSDATE;
2673: l_contact_point_rec.created_by := FND_GLOBAL.user_id;
2674: l_contact_point_rec.last_update_login := FND_GLOBAL.conc_login_id;
2675: l_contact_point_rec.object_version_number := 1;
2676: l_contact_point_rec.arc_contact_used_by := 'OFFR';
2677: l_contact_point_rec.act_contact_used_by_id := l_offer_rec.qp_list_header_id;
2678: l_contact_point_rec.contact_point_type := l_contact_point.contact_point_type;