APPS.AMS_PRICE_PVT dependencies on FND_API

Line 18: p_party_id number := FND_API.G_MISS_NUM

14: --select to_char(sysdate, 'sssss') into t from dual;
15: END GET_TIME;
16:
17: Function set_oe_Header_rec (
18: p_party_id number := FND_API.G_MISS_NUM
19: ,p_cust_account_id number := FND_API.G_MISS_NUM
20: ,p_price_list_id number := FND_API.G_MISS_NUM
21: ) return oe_order_pub.header_rec_type
22: is

Line 19: ,p_cust_account_id number := FND_API.G_MISS_NUM

15: END GET_TIME;
16:
17: Function set_oe_Header_rec (
18: p_party_id number := FND_API.G_MISS_NUM
19: ,p_cust_account_id number := FND_API.G_MISS_NUM
20: ,p_price_list_id number := FND_API.G_MISS_NUM
21: ) return oe_order_pub.header_rec_type
22: is
23: l_pricing_header_rec oe_order_pub.header_rec_type;

Line 20: ,p_price_list_id number := FND_API.G_MISS_NUM

16:
17: Function set_oe_Header_rec (
18: p_party_id number := FND_API.G_MISS_NUM
19: ,p_cust_account_id number := FND_API.G_MISS_NUM
20: ,p_price_list_id number := FND_API.G_MISS_NUM
21: ) return oe_order_pub.header_rec_type
22: is
23: l_pricing_header_rec oe_order_pub.header_rec_type;
24: begin

Line 32: p_party_id number := FND_API.G_MISS_NUM

28: return l_pricing_header_rec;
29: end set_oe_header_rec;
30:
31: Function set_aso_Header_rec (
32: p_party_id number := FND_API.G_MISS_NUM
33: ,p_cust_account_id number := FND_API.G_MISS_NUM
34: ,p_price_list_id number := FND_API.G_MISS_NUM
35: ) return aso_pricing_int.PRICING_HEADER_REC_TYPE
36: IS

Line 33: ,p_cust_account_id number := FND_API.G_MISS_NUM

29: end set_oe_header_rec;
30:
31: Function set_aso_Header_rec (
32: p_party_id number := FND_API.G_MISS_NUM
33: ,p_cust_account_id number := FND_API.G_MISS_NUM
34: ,p_price_list_id number := FND_API.G_MISS_NUM
35: ) return aso_pricing_int.PRICING_HEADER_REC_TYPE
36: IS
37: l_pricing_header_rec aso_pricing_int.PRICING_HEADER_REC_TYPE;

Line 34: ,p_price_list_id number := FND_API.G_MISS_NUM

30:
31: Function set_aso_Header_rec (
32: p_party_id number := FND_API.G_MISS_NUM
33: ,p_cust_account_id number := FND_API.G_MISS_NUM
34: ,p_price_list_id number := FND_API.G_MISS_NUM
35: ) return aso_pricing_int.PRICING_HEADER_REC_TYPE
36: IS
37: l_pricing_header_rec aso_pricing_int.PRICING_HEADER_REC_TYPE;
38: BEGIN

Line 47: p_inventory_item_id number := FND_API.G_MISS_NUM

43: END set_aso_header_rec;
44:
45:
46: Function set_oe_line_rec (
47: p_inventory_item_id number := FND_API.G_MISS_NUM
48: ,p_uom_code varchar2 := FND_API.G_MISS_CHAR
49: ,p_price_list_id number := FND_API.G_MISS_NUM
50: ,p_party_id number := FND_API.G_MISS_NUM
51: ,p_cust_account_id number := FND_API.G_MISS_NUM

Line 48: ,p_uom_code varchar2 := FND_API.G_MISS_CHAR

44:
45:
46: Function set_oe_line_rec (
47: p_inventory_item_id number := FND_API.G_MISS_NUM
48: ,p_uom_code varchar2 := FND_API.G_MISS_CHAR
49: ,p_price_list_id number := FND_API.G_MISS_NUM
50: ,p_party_id number := FND_API.G_MISS_NUM
51: ,p_cust_account_id number := FND_API.G_MISS_NUM
52: ) return oe_order_pub.line_rec_type

Line 49: ,p_price_list_id number := FND_API.G_MISS_NUM

45:
46: Function set_oe_line_rec (
47: p_inventory_item_id number := FND_API.G_MISS_NUM
48: ,p_uom_code varchar2 := FND_API.G_MISS_CHAR
49: ,p_price_list_id number := FND_API.G_MISS_NUM
50: ,p_party_id number := FND_API.G_MISS_NUM
51: ,p_cust_account_id number := FND_API.G_MISS_NUM
52: ) return oe_order_pub.line_rec_type
53: is

Line 50: ,p_party_id number := FND_API.G_MISS_NUM

46: Function set_oe_line_rec (
47: p_inventory_item_id number := FND_API.G_MISS_NUM
48: ,p_uom_code varchar2 := FND_API.G_MISS_CHAR
49: ,p_price_list_id number := FND_API.G_MISS_NUM
50: ,p_party_id number := FND_API.G_MISS_NUM
51: ,p_cust_account_id number := FND_API.G_MISS_NUM
52: ) return oe_order_pub.line_rec_type
53: is
54: l_pricing_line_rec oe_order_pub.line_rec_type;

Line 51: ,p_cust_account_id number := FND_API.G_MISS_NUM

47: p_inventory_item_id number := FND_API.G_MISS_NUM
48: ,p_uom_code varchar2 := FND_API.G_MISS_CHAR
49: ,p_price_list_id number := FND_API.G_MISS_NUM
50: ,p_party_id number := FND_API.G_MISS_NUM
51: ,p_cust_account_id number := FND_API.G_MISS_NUM
52: ) return oe_order_pub.line_rec_type
53: is
54: l_pricing_line_rec oe_order_pub.line_rec_type;
55: begin

Line 67: p_inventory_item_id number := FND_API.G_MISS_NUM

63: end set_oe_line_rec;
64:
65:
66: Function set_aso_line_rec (
67: p_inventory_item_id number := FND_API.G_MISS_NUM
68: ,p_uom_code varchar2 := FND_API.G_MISS_CHAR
69: ,p_price_list_id number := FND_API.G_MISS_NUM
70: ,p_party_id number := FND_API.G_MISS_NUM
71: ,p_cust_account_id number := FND_API.G_MISS_NUM

Line 68: ,p_uom_code varchar2 := FND_API.G_MISS_CHAR

64:
65:
66: Function set_aso_line_rec (
67: p_inventory_item_id number := FND_API.G_MISS_NUM
68: ,p_uom_code varchar2 := FND_API.G_MISS_CHAR
69: ,p_price_list_id number := FND_API.G_MISS_NUM
70: ,p_party_id number := FND_API.G_MISS_NUM
71: ,p_cust_account_id number := FND_API.G_MISS_NUM
72: ) return aso_pricing_int.PRICING_line_REC_TYPE

Line 69: ,p_price_list_id number := FND_API.G_MISS_NUM

65:
66: Function set_aso_line_rec (
67: p_inventory_item_id number := FND_API.G_MISS_NUM
68: ,p_uom_code varchar2 := FND_API.G_MISS_CHAR
69: ,p_price_list_id number := FND_API.G_MISS_NUM
70: ,p_party_id number := FND_API.G_MISS_NUM
71: ,p_cust_account_id number := FND_API.G_MISS_NUM
72: ) return aso_pricing_int.PRICING_line_REC_TYPE
73: is

Line 70: ,p_party_id number := FND_API.G_MISS_NUM

66: Function set_aso_line_rec (
67: p_inventory_item_id number := FND_API.G_MISS_NUM
68: ,p_uom_code varchar2 := FND_API.G_MISS_CHAR
69: ,p_price_list_id number := FND_API.G_MISS_NUM
70: ,p_party_id number := FND_API.G_MISS_NUM
71: ,p_cust_account_id number := FND_API.G_MISS_NUM
72: ) return aso_pricing_int.PRICING_line_REC_TYPE
73: is
74: l_pricing_line_rec aso_pricing_int.PRICING_line_REC_TYPE;

Line 71: ,p_cust_account_id number := FND_API.G_MISS_NUM

67: p_inventory_item_id number := FND_API.G_MISS_NUM
68: ,p_uom_code varchar2 := FND_API.G_MISS_CHAR
69: ,p_price_list_id number := FND_API.G_MISS_NUM
70: ,p_party_id number := FND_API.G_MISS_NUM
71: ,p_cust_account_id number := FND_API.G_MISS_NUM
72: ) return aso_pricing_int.PRICING_line_REC_TYPE
73: is
74: l_pricing_line_rec aso_pricing_int.PRICING_line_REC_TYPE;
75: begin

Line 134: ,p_price_list_id in number := FND_API.G_MISS_NUM

130:
131: Procedure getReqLineAttrAndQual(
132: p_inventory_item_id in number
133: ,p_uom_code in varchar2
134: ,p_price_list_id in number := FND_API.G_MISS_NUM
135: ,p_party_id in number := FND_API.G_MISS_NUM
136: ,p_cust_account_id in number := FND_API.G_MISS_NUM
137: ,p_line_index in number
138: ,p_request_type_code in varchar2

Line 135: ,p_party_id in number := FND_API.G_MISS_NUM

131: Procedure getReqLineAttrAndQual(
132: p_inventory_item_id in number
133: ,p_uom_code in varchar2
134: ,p_price_list_id in number := FND_API.G_MISS_NUM
135: ,p_party_id in number := FND_API.G_MISS_NUM
136: ,p_cust_account_id in number := FND_API.G_MISS_NUM
137: ,p_line_index in number
138: ,p_request_type_code in varchar2
139: ,px_req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE

Line 136: ,p_cust_account_id in number := FND_API.G_MISS_NUM

132: p_inventory_item_id in number
133: ,p_uom_code in varchar2
134: ,p_price_list_id in number := FND_API.G_MISS_NUM
135: ,p_party_id in number := FND_API.G_MISS_NUM
136: ,p_cust_account_id in number := FND_API.G_MISS_NUM
137: ,p_line_index in number
138: ,p_request_type_code in varchar2
139: ,px_req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
140: ,px_req_qual_tbl in out nocopy QP_PREQ_GRP.qual_TBL_TYPE

Line 199: p_party_id in number := FND_API.G_MISS_NUM

195: end getREQLineAttrAndQual;
196:
197:
198: Procedure getHeaderAttrAndQual(
199: p_party_id in number := FND_API.G_MISS_NUM
200: ,p_cust_account_id in number := FND_API.G_MISS_NUM
201: ,p_price_list_id in number := FND_API.G_MISS_NUM
202: ,p_request_type_code in varchar2
203: ,x_pricing_contexts_tbl out nocopy QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type

Line 200: ,p_cust_account_id in number := FND_API.G_MISS_NUM

196:
197:
198: Procedure getHeaderAttrAndQual(
199: p_party_id in number := FND_API.G_MISS_NUM
200: ,p_cust_account_id in number := FND_API.G_MISS_NUM
201: ,p_price_list_id in number := FND_API.G_MISS_NUM
202: ,p_request_type_code in varchar2
203: ,x_pricing_contexts_tbl out nocopy QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
204: ,x_qual_contexts_tbl out nocopy QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type

Line 201: ,p_price_list_id in number := FND_API.G_MISS_NUM

197:
198: Procedure getHeaderAttrAndQual(
199: p_party_id in number := FND_API.G_MISS_NUM
200: ,p_cust_account_id in number := FND_API.G_MISS_NUM
201: ,p_price_list_id in number := FND_API.G_MISS_NUM
202: ,p_request_type_code in varchar2
203: ,x_pricing_contexts_tbl out nocopy QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
204: ,x_qual_contexts_tbl out nocopy QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
205: )

Line 239: p_party_id in number := FND_API.G_MISS_NUM

235:
236: --- wendy start only used by testing purpose
237:
238: Procedure getReqHeaderAttrAndQual(
239: p_party_id in number := FND_API.G_MISS_NUM
240: ,p_cust_account_id in number := FND_API.G_MISS_NUM
241: ,p_price_list_id in number := FND_API.G_MISS_NUM
242: ,p_line_index in number
243: ,p_request_type_code in varchar2

Line 240: ,p_cust_account_id in number := FND_API.G_MISS_NUM

236: --- wendy start only used by testing purpose
237:
238: Procedure getReqHeaderAttrAndQual(
239: p_party_id in number := FND_API.G_MISS_NUM
240: ,p_cust_account_id in number := FND_API.G_MISS_NUM
241: ,p_price_list_id in number := FND_API.G_MISS_NUM
242: ,p_line_index in number
243: ,p_request_type_code in varchar2
244: ,px_req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE

Line 241: ,p_price_list_id in number := FND_API.G_MISS_NUM

237:
238: Procedure getReqHeaderAttrAndQual(
239: p_party_id in number := FND_API.G_MISS_NUM
240: ,p_cust_account_id in number := FND_API.G_MISS_NUM
241: ,p_price_list_id in number := FND_API.G_MISS_NUM
242: ,p_line_index in number
243: ,p_request_type_code in varchar2
244: ,px_req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
245: ,px_req_qual_tbl in out nocopy QP_PREQ_GRP.qual_TBL_TYPE

Line 422: ,p_price_list_id in number := FND_API.G_MISS_NUM

418: PROCEDURE SetRequest(
419: p_inventory_item_id in number
420: ,p_uom_code in varchar2
421: ,p_currency_code in varchar2
422: ,p_price_list_id in number := FND_API.G_MISS_NUM
423: ,p_party_id in number := FND_API.G_MISS_NUM
424: ,p_cust_account_id in number := FND_API.G_MISS_NUM
425: ,p_line_id in number
426: ,p_line_index in number

Line 423: ,p_party_id in number := FND_API.G_MISS_NUM

419: p_inventory_item_id in number
420: ,p_uom_code in varchar2
421: ,p_currency_code in varchar2
422: ,p_price_list_id in number := FND_API.G_MISS_NUM
423: ,p_party_id in number := FND_API.G_MISS_NUM
424: ,p_cust_account_id in number := FND_API.G_MISS_NUM
425: ,p_line_id in number
426: ,p_line_index in number
427: ,p_request_type_code varchar2

Line 424: ,p_cust_account_id in number := FND_API.G_MISS_NUM

420: ,p_uom_code in varchar2
421: ,p_currency_code in varchar2
422: ,p_price_list_id in number := FND_API.G_MISS_NUM
423: ,p_party_id in number := FND_API.G_MISS_NUM
424: ,p_cust_account_id in number := FND_API.G_MISS_NUM
425: ,p_line_id in number
426: ,p_line_index in number
427: ,p_request_type_code varchar2
428: ,p_pricing_contexts_tbl in QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type

Line 489: p_price_list_id IN NUMBER := FND_API.G_MISS_NUM

485: END clear_Global_Structures;
486:
487:
488: PROCEDURE GetPricesFromQP(
489: p_price_list_id IN NUMBER := FND_API.G_MISS_NUM
490: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
491: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
492: ,p_currency_code IN VARCHAR2
493: ,p_item_tbl IN JTF_NUMBER_TABLE

Line 490: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM

486:
487:
488: PROCEDURE GetPricesFromQP(
489: p_price_list_id IN NUMBER := FND_API.G_MISS_NUM
490: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
491: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
492: ,p_currency_code IN VARCHAR2
493: ,p_item_tbl IN JTF_NUMBER_TABLE
494: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100

Line 491: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM

487:
488: PROCEDURE GetPricesFromQP(
489: p_price_list_id IN NUMBER := FND_API.G_MISS_NUM
490: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
491: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
492: ,p_currency_code IN VARCHAR2
493: ,p_item_tbl IN JTF_NUMBER_TABLE
494: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
495: ,p_parentIndex_tbl IN JTF_NUMBER_TABLE := null