DBA Data[Home] [Help]

APPS.OZF_COPY_OFFER_PVT dependencies on FND_GLOBAL

Line 1224: ,FND_GLOBAL.user_id

1220: ,l_line_detail.start_date_active
1221: ,l_line_detail.end_date_active
1222: ,l_line_detail.uom_code
1223: ,SYSDATE
1224: ,FND_GLOBAL.user_id
1225: ,SYSDATE
1226: ,FND_GLOBAL.user_id
1227: ,FND_GLOBAL.conc_login_id
1228: ,1

Line 1226: ,FND_GLOBAL.user_id

1222: ,l_line_detail.uom_code
1223: ,SYSDATE
1224: ,FND_GLOBAL.user_id
1225: ,SYSDATE
1226: ,FND_GLOBAL.user_id
1227: ,FND_GLOBAL.conc_login_id
1228: ,1
1229: ,p_offer_id);
1230: END copy_discount_line;

Line 1227: ,FND_GLOBAL.conc_login_id

1223: ,SYSDATE
1224: ,FND_GLOBAL.user_id
1225: ,SYSDATE
1226: ,FND_GLOBAL.user_id
1227: ,FND_GLOBAL.conc_login_id
1228: ,1
1229: ,p_offer_id);
1230: END copy_discount_line;
1231:

Line 1302: ,FND_GLOBAL.user_id

1298: ,l_product_detail.end_date_active
1299: ,p_new_line_id
1300: ,p_offer_id
1301: ,SYSDATE
1302: ,FND_GLOBAL.user_id
1303: ,SYSDATE
1304: ,FND_GLOBAL.user_id
1305: ,FND_GLOBAL.conc_login_id
1306: ,1

Line 1304: ,FND_GLOBAL.user_id

1300: ,p_offer_id
1301: ,SYSDATE
1302: ,FND_GLOBAL.user_id
1303: ,SYSDATE
1304: ,FND_GLOBAL.user_id
1305: ,FND_GLOBAL.conc_login_id
1306: ,1
1307: ,p_parent_prod_id);
1308: END copy_discount_prod;

Line 1305: ,FND_GLOBAL.conc_login_id

1301: ,SYSDATE
1302: ,FND_GLOBAL.user_id
1303: ,SYSDATE
1304: ,FND_GLOBAL.user_id
1305: ,FND_GLOBAL.conc_login_id
1306: ,1
1307: ,p_parent_prod_id);
1308: END copy_discount_prod;
1309:

Line 1493: ,FND_GLOBAL.user_id

1489: ,active_flag
1490: ,object_version_number)
1491: VALUES(l_new_qual_id
1492: ,SYSDATE
1493: ,FND_GLOBAL.user_id
1494: ,SYSDATE
1495: ,FND_GLOBAL.user_id
1496: ,FND_GLOBAL.conc_login_id
1497: ,l_market_elig.qualifier_grouping_no

Line 1495: ,FND_GLOBAL.user_id

1491: VALUES(l_new_qual_id
1492: ,SYSDATE
1493: ,FND_GLOBAL.user_id
1494: ,SYSDATE
1495: ,FND_GLOBAL.user_id
1496: ,FND_GLOBAL.conc_login_id
1497: ,l_market_elig.qualifier_grouping_no
1498: ,l_market_elig.qualifier_context
1499: ,l_market_elig.qualifier_attribute

Line 1496: ,FND_GLOBAL.conc_login_id

1492: ,SYSDATE
1493: ,FND_GLOBAL.user_id
1494: ,SYSDATE
1495: ,FND_GLOBAL.user_id
1496: ,FND_GLOBAL.conc_login_id
1497: ,l_market_elig.qualifier_grouping_no
1498: ,l_market_elig.qualifier_context
1499: ,l_market_elig.qualifier_attribute
1500: ,l_market_elig.qualifier_attr_value

Line 1968: ,FND_GLOBAL.user_id

1964: ,l_offer_rec.qualifier_id
1965: ,l_offer_rec.qualifier_type
1966: ,DECODE(l_offer_rec.custom_setup_id, 101, 'Y', 108, 'Y', 'N')--l_offer_rec.budget_offer_yn
1967: ,SYSDATE
1968: ,FND_GLOBAL.user_id
1969: ,FND_GLOBAL.user_id
1970: ,SYSDATE
1971: ,FND_GLOBAL.conc_login_id
1972: ,NULL

Line 1969: ,FND_GLOBAL.user_id

1965: ,l_offer_rec.qualifier_type
1966: ,DECODE(l_offer_rec.custom_setup_id, 101, 'Y', 108, 'Y', 'N')--l_offer_rec.budget_offer_yn
1967: ,SYSDATE
1968: ,FND_GLOBAL.user_id
1969: ,FND_GLOBAL.user_id
1970: ,SYSDATE
1971: ,FND_GLOBAL.conc_login_id
1972: ,NULL
1973: ,l_offer_rec.break_type

Line 1971: ,FND_GLOBAL.conc_login_id

1967: ,SYSDATE
1968: ,FND_GLOBAL.user_id
1969: ,FND_GLOBAL.user_id
1970: ,SYSDATE
1971: ,FND_GLOBAL.conc_login_id
1972: ,NULL
1973: ,l_offer_rec.break_type
1974: ,l_offer_rec.volume_offer_type
1975: ,l_offer_rec.confidential_flag

Line 2026: ,FND_GLOBAL.user_id

2022: ,owner_flag)
2023: VALUES
2024: (ams_act_access_s.NEXTVAL
2025: ,SYSDATE
2026: ,FND_GLOBAL.user_id
2027: ,SYSDATE
2028: ,FND_GLOBAL.user_id
2029: ,l_offer_rec.qp_list_header_id
2030: ,'OFFR'

Line 2028: ,FND_GLOBAL.user_id

2024: (ams_act_access_s.NEXTVAL
2025: ,SYSDATE
2026: ,FND_GLOBAL.user_id
2027: ,SYSDATE
2028: ,FND_GLOBAL.user_id
2029: ,l_offer_rec.qp_list_header_id
2030: ,'OFFR'
2031: ,l_offer_rec.owner_id
2032: ,'USER'

Line 2033: ,FND_GLOBAL.conc_login_id

2029: ,l_offer_rec.qp_list_header_id
2030: ,'OFFR'
2031: ,l_offer_rec.owner_id
2032: ,'USER'
2033: ,FND_GLOBAL.conc_login_id
2034: ,1
2035: ,SYSDATE
2036: ,NULL
2037: ,NULL

Line 2068: ,FND_GLOBAL.conc_login_id

2064: ,l_offer_rec.offer_code
2065: ,NULL
2066: ,SYSDATE
2067: ,SYSDATE
2068: ,FND_GLOBAL.conc_login_id
2069: ,FND_GLOBAL.user_id
2070: ,FND_GLOBAL.user_id);
2071: -- end create access in ams_act_access_denorm
2072:

Line 2069: ,FND_GLOBAL.user_id

2065: ,NULL
2066: ,SYSDATE
2067: ,SYSDATE
2068: ,FND_GLOBAL.conc_login_id
2069: ,FND_GLOBAL.user_id
2070: ,FND_GLOBAL.user_id);
2071: -- end create access in ams_act_access_denorm
2072:
2073: -- create access for default team

Line 2070: ,FND_GLOBAL.user_id);

2066: ,SYSDATE
2067: ,SYSDATE
2068: ,FND_GLOBAL.conc_login_id
2069: ,FND_GLOBAL.user_id
2070: ,FND_GLOBAL.user_id);
2071: -- end create access in ams_act_access_denorm
2072:
2073: -- create access for default team
2074: l_default_team := FND_PROFILE.value('OZF_DEFAULT_OFFER_TEAM');

Line 2098: ,FND_GLOBAL.user_id

2094: ,owner_flag)
2095: VALUES
2096: (ams_act_access_s.NEXTVAL
2097: ,SYSDATE
2098: ,FND_GLOBAL.user_id
2099: ,SYSDATE
2100: ,FND_GLOBAL.user_id
2101: ,l_offer_rec.qp_list_header_id
2102: ,'OFFR'

Line 2100: ,FND_GLOBAL.user_id

2096: (ams_act_access_s.NEXTVAL
2097: ,SYSDATE
2098: ,FND_GLOBAL.user_id
2099: ,SYSDATE
2100: ,FND_GLOBAL.user_id
2101: ,l_offer_rec.qp_list_header_id
2102: ,'OFFR'
2103: ,l_default_team
2104: ,'GROUP'

Line 2105: ,FND_GLOBAL.conc_login_id

2101: ,l_offer_rec.qp_list_header_id
2102: ,'OFFR'
2103: ,l_default_team
2104: ,'GROUP'
2105: ,FND_GLOBAL.conc_login_id
2106: ,1
2107: ,SYSDATE
2108: ,NULL
2109: ,NULL

Line 2199: ,FND_GLOBAL.user_id

2195: ,total_attr_count)
2196: VALUES
2197: (l_new_limit_id
2198: ,SYSDATE
2199: ,FND_GLOBAL.user_id
2200: ,SYSDATE
2201: ,FND_GLOBAL.user_id
2202: ,FND_GLOBAL.conc_login_id
2203: ,l_line_limits.program_application_id

Line 2201: ,FND_GLOBAL.user_id

2197: (l_new_limit_id
2198: ,SYSDATE
2199: ,FND_GLOBAL.user_id
2200: ,SYSDATE
2201: ,FND_GLOBAL.user_id
2202: ,FND_GLOBAL.conc_login_id
2203: ,l_line_limits.program_application_id
2204: ,l_line_limits.program_id
2205: ,SYSDATE

Line 2202: ,FND_GLOBAL.conc_login_id

2198: ,SYSDATE
2199: ,FND_GLOBAL.user_id
2200: ,SYSDATE
2201: ,FND_GLOBAL.user_id
2202: ,FND_GLOBAL.conc_login_id
2203: ,l_line_limits.program_application_id
2204: ,l_line_limits.program_id
2205: ,SYSDATE
2206: ,NULL

Line 2322: ,FND_GLOBAL.user_id

2318: ,total_attr_count)
2319: VALUES
2320: (l_new_limit_id
2321: ,SYSDATE
2322: ,FND_GLOBAL.user_id
2323: ,SYSDATE
2324: ,FND_GLOBAL.user_id
2325: ,FND_GLOBAL.conc_login_id
2326: ,l_line_limits.program_application_id

Line 2324: ,FND_GLOBAL.user_id

2320: (l_new_limit_id
2321: ,SYSDATE
2322: ,FND_GLOBAL.user_id
2323: ,SYSDATE
2324: ,FND_GLOBAL.user_id
2325: ,FND_GLOBAL.conc_login_id
2326: ,l_line_limits.program_application_id
2327: ,l_line_limits.program_id
2328: ,SYSDATE

Line 2325: ,FND_GLOBAL.conc_login_id

2321: ,SYSDATE
2322: ,FND_GLOBAL.user_id
2323: ,SYSDATE
2324: ,FND_GLOBAL.user_id
2325: ,FND_GLOBAL.conc_login_id
2326: ,l_line_limits.program_application_id
2327: ,l_line_limits.program_id
2328: ,SYSDATE
2329: ,NULL

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

2598: IF AMS_CpyUtility_PVT.is_copy_attribute ('CPNT', p_attributes_table) = FND_API.G_TRUE THEN
2599: FOR l_contact_point IN c_contact_point LOOP
2600: l_contact_point_rec.contact_point_id := Fnd_Api.g_miss_num;
2601: l_contact_point_rec.last_update_date := SYSDATE;
2602: l_contact_point_rec.last_updated_by := FND_GLOBAL.user_id;
2603: l_contact_point_rec.creation_date := SYSDATE;
2604: l_contact_point_rec.created_by := FND_GLOBAL.user_id;
2605: l_contact_point_rec.last_update_login := FND_GLOBAL.conc_login_id;
2606: l_contact_point_rec.object_version_number := 1;

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

2600: l_contact_point_rec.contact_point_id := Fnd_Api.g_miss_num;
2601: l_contact_point_rec.last_update_date := SYSDATE;
2602: l_contact_point_rec.last_updated_by := FND_GLOBAL.user_id;
2603: l_contact_point_rec.creation_date := SYSDATE;
2604: l_contact_point_rec.created_by := FND_GLOBAL.user_id;
2605: l_contact_point_rec.last_update_login := FND_GLOBAL.conc_login_id;
2606: l_contact_point_rec.object_version_number := 1;
2607: l_contact_point_rec.arc_contact_used_by := 'OFFR';
2608: l_contact_point_rec.act_contact_used_by_id := l_offer_rec.qp_list_header_id;

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

2601: l_contact_point_rec.last_update_date := SYSDATE;
2602: l_contact_point_rec.last_updated_by := FND_GLOBAL.user_id;
2603: l_contact_point_rec.creation_date := SYSDATE;
2604: l_contact_point_rec.created_by := FND_GLOBAL.user_id;
2605: l_contact_point_rec.last_update_login := FND_GLOBAL.conc_login_id;
2606: l_contact_point_rec.object_version_number := 1;
2607: l_contact_point_rec.arc_contact_used_by := 'OFFR';
2608: l_contact_point_rec.act_contact_used_by_id := l_offer_rec.qp_list_header_id;
2609: l_contact_point_rec.contact_point_type := l_contact_point.contact_point_type;