DBA Data[Home] [Help]

APPS.OE_PRICE_LIST_UTIL dependencies on QP_QUALIFIERS_S

Line 977: QP_QUALIFIERS_S.nextval,

973: ,ORIG_SYS_QUALIFIER_REF
974: ,ORIG_SYS_HEADER_REF
975: )
976: VALUES (
977: QP_QUALIFIERS_S.nextval,
978: sysdate,
979: 1,
980: sysdate,
981: 1,

Line 991: ,to_char(QP_QUALIFIERS_S.CURRVAL)

987: to_char(p_PRICE_LIST_rec.price_list_id),
988: qp.qp_qualifier_group_no_s.nextval,
989: 'N'
990: --ENH Upgrade BOAPI for orig_sys...ref RAVI
991: ,to_char(QP_QUALIFIERS_S.CURRVAL)
992: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=p_PRICE_LIST_rec.secondary_price_list_id)
993: );
994:
995: END IF;

Line 1096: QP_QUALIFIERS_S.nextval,

1092: --ENH Upgrade BOAPI for orig_sys...ref RAVI
1093: ,ORIG_SYS_QUALIFIER_REF
1094: ,ORIG_SYS_HEADER_REF)
1095: VALUES (
1096: QP_QUALIFIERS_S.nextval,
1097: sysdate,
1098: 1,
1099: sysdate,
1100: 1,

Line 1110: ,to_char(QP_QUALIFIERS_S.CURRVAL)

1106: to_char(p_PRICE_LIST_rec.price_list_id),
1107: qp_qualifier_group_no_s.nextval,
1108: 'N'
1109: --ENH Upgrade BOAPI for orig_sys...ref RAVI
1110: ,to_char(QP_QUALIFIERS_S.CURRVAL)
1111: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=p_PRICE_LIST_rec.price_list_id)
1112: );
1113:
1114: /* create qualifier for secondary price list */

Line 1137: QP_QUALIFIERS_S.nextval,

1133: ,ORIG_SYS_QUALIFIER_REF
1134: ,ORIG_SYS_HEADER_REF
1135: )
1136: VALUES (
1137: QP_QUALIFIERS_S.nextval,
1138: sysdate,
1139: 1,
1140: sysdate,
1141: 1,

Line 1151: ,to_char(QP_QUALIFIERS_S.CURRVAL)

1147: to_char(p_PRICE_LIST_rec.price_list_id),
1148: qp_qualifier_group_no_s.nextval,
1149: 'N'
1150: --ENH Upgrade BOAPI for orig_sys...ref RAVI
1151: ,to_char(QP_QUALIFIERS_S.CURRVAL)
1152: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=p_PRICE_LIST_rec.secondary_price_list_id)
1153: );
1154: END IF;
1155: