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
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;
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:
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
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;
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:
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
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
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
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
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
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
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'
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'
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
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:
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
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');
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'
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'
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
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
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
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
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
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
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
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;
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;
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;