APPS.ZX_PRD_OPTIONS_MIGRATE_PKG dependencies on ZX_PRODUCT_OPTIONS_ALL_S

Line 341: values (ZX_PRODUCT_OPTIONS_ALL_S.nextval,

337: LAST_UPDATE_DATE,
338: LAST_UPDATED_BY,
339: LAST_UPDATE_LOGIN
340: )
341: values (ZX_PRODUCT_OPTIONS_ALL_S.nextval,
342: ap_system_options.ORG_ID(i),
343: 200, --application_id
344: ap_system_options.DEFAULT_HIERARCHY1(i),
345: ap_system_options.DEFAULT_HIERARCHY2(i),

Line 582: values (ZX_PRODUCT_OPTIONS_ALL_S.nextval,

578: LAST_UPDATE_DATE,
579: LAST_UPDATED_BY,
580: LAST_UPDATE_LOGIN
581: )
582: values (ZX_PRODUCT_OPTIONS_ALL_S.nextval,
583: ar_system_options.ORG_ID(i),
584: 222, --application_id
585: ar_system_options.DEFAULT_HIERARCHY1(i),
586: ar_system_options.DEFAULT_HIERARCHY2(i),

Line 807: values (ZX_PRODUCT_OPTIONS_ALL_S.nextval,

803: LAST_UPDATE_DATE,
804: LAST_UPDATED_BY,
805: LAST_UPDATE_LOGIN
806: )
807: values (ZX_PRODUCT_OPTIONS_ALL_S.nextval,
808: po_system_options.ORG_ID(i),
809: 201, --application_id
810: po_system_options.DEFAULT_HIERARCHY1(i),
811: po_system_options.DEFAULT_HIERARCHY2(i),

Line 1062: values (ZX_PRODUCT_OPTIONS_ALL_S.nextval,

1058: LAST_UPDATE_DATE,
1059: LAST_UPDATED_BY,
1060: LAST_UPDATE_LOGIN
1061: )
1062: values (ZX_PRODUCT_OPTIONS_ALL_S.nextval,
1063: pa_system_options.org_id(i),
1064: 275, --application_id
1065: pa_system_options.DEFAULT_HIERARCHY1(i),
1066: pa_system_options.DEFAULT_HIERARCHY2(i),

Line 1153: SELECT ZX_PRODUCT_OPTIONS_ALL_S.nextval,

1149: LAST_UPDATE_DATE,
1150: LAST_UPDATED_BY,
1151: LAST_UPDATE_LOGIN
1152: )
1153: SELECT ZX_PRODUCT_OPTIONS_ALL_S.nextval,
1154: decode(l_multi_org_flag,'N',l_org_id,prd.org_id),
1155: prd.application_id,
1156: mapp.event_class_mapping_id,
1157: prd.def_option_hier_1_code,