DBA Data[Home] [Help]

APPS.ASO_QUOTE_HEADER_DEP_HDLR dependencies on ASO_DEFAULTING_INT

Line 11: , X_Q_CONTRACT_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type

7: -- End of Comments
8:
9: PROCEDURE Get_Dependent_Attributes_Sets
10: ( P_INIT_MSG_LIST IN VARCHAR2 := fnd_api.g_false
11: , X_Q_CONTRACT_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
12: , X_Q_CUST_ACCOUNT_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
13: , X_Q_CUST_PARTY_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
14: , X_Q_INV_TO_CUST_ACCT_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
15: , X_Q_INV_TO_PTY_SITE_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type

Line 12: , X_Q_CUST_ACCOUNT_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type

8:
9: PROCEDURE Get_Dependent_Attributes_Sets
10: ( P_INIT_MSG_LIST IN VARCHAR2 := fnd_api.g_false
11: , X_Q_CONTRACT_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
12: , X_Q_CUST_ACCOUNT_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
13: , X_Q_CUST_PARTY_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
14: , X_Q_INV_TO_CUST_ACCT_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
15: , X_Q_INV_TO_PTY_SITE_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
16: , X_Q_ORDER_TYPE_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type

Line 13: , X_Q_CUST_PARTY_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type

9: PROCEDURE Get_Dependent_Attributes_Sets
10: ( P_INIT_MSG_LIST IN VARCHAR2 := fnd_api.g_false
11: , X_Q_CONTRACT_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
12: , X_Q_CUST_ACCOUNT_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
13: , X_Q_CUST_PARTY_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
14: , X_Q_INV_TO_CUST_ACCT_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
15: , X_Q_INV_TO_PTY_SITE_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
16: , X_Q_ORDER_TYPE_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
17: , X_Q_ORG_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type

Line 14: , X_Q_INV_TO_CUST_ACCT_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type

10: ( P_INIT_MSG_LIST IN VARCHAR2 := fnd_api.g_false
11: , X_Q_CONTRACT_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
12: , X_Q_CUST_ACCOUNT_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
13: , X_Q_CUST_PARTY_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
14: , X_Q_INV_TO_CUST_ACCT_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
15: , X_Q_INV_TO_PTY_SITE_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
16: , X_Q_ORDER_TYPE_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
17: , X_Q_ORG_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
18: , X_Q_PRICE_LIST_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type

Line 15: , X_Q_INV_TO_PTY_SITE_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type

11: , X_Q_CONTRACT_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
12: , X_Q_CUST_ACCOUNT_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
13: , X_Q_CUST_PARTY_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
14: , X_Q_INV_TO_CUST_ACCT_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
15: , X_Q_INV_TO_PTY_SITE_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
16: , X_Q_ORDER_TYPE_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
17: , X_Q_ORG_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
18: , X_Q_PRICE_LIST_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
19: , X_Q_RESOURCE_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type

Line 16: , X_Q_ORDER_TYPE_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type

12: , X_Q_CUST_ACCOUNT_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
13: , X_Q_CUST_PARTY_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
14: , X_Q_INV_TO_CUST_ACCT_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
15: , X_Q_INV_TO_PTY_SITE_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
16: , X_Q_ORDER_TYPE_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
17: , X_Q_ORG_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
18: , X_Q_PRICE_LIST_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
19: , X_Q_RESOURCE_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
20: , X_Q_SHIP_TO_CUST_ACCT_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type

Line 17: , X_Q_ORG_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type

13: , X_Q_CUST_PARTY_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
14: , X_Q_INV_TO_CUST_ACCT_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
15: , X_Q_INV_TO_PTY_SITE_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
16: , X_Q_ORDER_TYPE_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
17: , X_Q_ORG_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
18: , X_Q_PRICE_LIST_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
19: , X_Q_RESOURCE_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
20: , X_Q_SHIP_TO_CUST_ACCT_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
21: , X_Q_SHIP_TO_PARTY_SITE_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type

Line 18: , X_Q_PRICE_LIST_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type

14: , X_Q_INV_TO_CUST_ACCT_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
15: , X_Q_INV_TO_PTY_SITE_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
16: , X_Q_ORDER_TYPE_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
17: , X_Q_ORG_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
18: , X_Q_PRICE_LIST_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
19: , X_Q_RESOURCE_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
20: , X_Q_SHIP_TO_CUST_ACCT_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
21: , X_Q_SHIP_TO_PARTY_SITE_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
22: , X_RETURN_STATUS OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 19: , X_Q_RESOURCE_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type

15: , X_Q_INV_TO_PTY_SITE_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
16: , X_Q_ORDER_TYPE_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
17: , X_Q_ORG_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
18: , X_Q_PRICE_LIST_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
19: , X_Q_RESOURCE_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
20: , X_Q_SHIP_TO_CUST_ACCT_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
21: , X_Q_SHIP_TO_PARTY_SITE_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
22: , X_RETURN_STATUS OUT NOCOPY /* file.sql.39 change */ VARCHAR2
23: , X_MSG_COUNT OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 20: , X_Q_SHIP_TO_CUST_ACCT_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type

16: , X_Q_ORDER_TYPE_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
17: , X_Q_ORG_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
18: , X_Q_PRICE_LIST_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
19: , X_Q_RESOURCE_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
20: , X_Q_SHIP_TO_CUST_ACCT_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
21: , X_Q_SHIP_TO_PARTY_SITE_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
22: , X_RETURN_STATUS OUT NOCOPY /* file.sql.39 change */ VARCHAR2
23: , X_MSG_COUNT OUT NOCOPY /* file.sql.39 change */ NUMBER
24: , X_MSG_DATA OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 21: , X_Q_SHIP_TO_PARTY_SITE_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type

17: , X_Q_ORG_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
18: , X_Q_PRICE_LIST_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
19: , X_Q_RESOURCE_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
20: , X_Q_SHIP_TO_CUST_ACCT_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
21: , X_Q_SHIP_TO_PARTY_SITE_ID_TBL OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
22: , X_RETURN_STATUS OUT NOCOPY /* file.sql.39 change */ VARCHAR2
23: , X_MSG_COUNT OUT NOCOPY /* file.sql.39 change */ NUMBER
24: , X_MSG_DATA OUT NOCOPY /* file.sql.39 change */ VARCHAR2
25: );

Line 30: , P_TRIGGERS_ID_TBL IN ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type

26:
27: PROCEDURE Get_Dependent_Attributes_Proc
28: ( P_INIT_MSG_LIST IN VARCHAR2 := fnd_api.g_false
29: , P_TRIGGER_RECORD IN ASO_AK_QUOTE_HEADER_V%ROWTYPE
30: , P_TRIGGERS_ID_TBL IN ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
31: := ASO_DEFAULTING_INT.G_MISS_ATTRIBUTE_IDS_TBL
32: , P_CONTROL_RECORD IN ASO_DEFAULTING_INT.Control_Rec_Type
33: := ASO_DEFAULTING_INT.G_MISS_CONTROL_REC
34: , X_DEPENDENT_RECORD OUT NOCOPY /* file.sql.39 change */ ASO_AK_QUOTE_HEADER_V%ROWTYPE

Line 31: := ASO_DEFAULTING_INT.G_MISS_ATTRIBUTE_IDS_TBL

27: PROCEDURE Get_Dependent_Attributes_Proc
28: ( P_INIT_MSG_LIST IN VARCHAR2 := fnd_api.g_false
29: , P_TRIGGER_RECORD IN ASO_AK_QUOTE_HEADER_V%ROWTYPE
30: , P_TRIGGERS_ID_TBL IN ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
31: := ASO_DEFAULTING_INT.G_MISS_ATTRIBUTE_IDS_TBL
32: , P_CONTROL_RECORD IN ASO_DEFAULTING_INT.Control_Rec_Type
33: := ASO_DEFAULTING_INT.G_MISS_CONTROL_REC
34: , X_DEPENDENT_RECORD OUT NOCOPY /* file.sql.39 change */ ASO_AK_QUOTE_HEADER_V%ROWTYPE
35: , X_RETURN_STATUS OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 32: , P_CONTROL_RECORD IN ASO_DEFAULTING_INT.Control_Rec_Type

28: ( P_INIT_MSG_LIST IN VARCHAR2 := fnd_api.g_false
29: , P_TRIGGER_RECORD IN ASO_AK_QUOTE_HEADER_V%ROWTYPE
30: , P_TRIGGERS_ID_TBL IN ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
31: := ASO_DEFAULTING_INT.G_MISS_ATTRIBUTE_IDS_TBL
32: , P_CONTROL_RECORD IN ASO_DEFAULTING_INT.Control_Rec_Type
33: := ASO_DEFAULTING_INT.G_MISS_CONTROL_REC
34: , X_DEPENDENT_RECORD OUT NOCOPY /* file.sql.39 change */ ASO_AK_QUOTE_HEADER_V%ROWTYPE
35: , X_RETURN_STATUS OUT NOCOPY /* file.sql.39 change */ VARCHAR2
36: , X_MSG_COUNT OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 33: := ASO_DEFAULTING_INT.G_MISS_CONTROL_REC

29: , P_TRIGGER_RECORD IN ASO_AK_QUOTE_HEADER_V%ROWTYPE
30: , P_TRIGGERS_ID_TBL IN ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
31: := ASO_DEFAULTING_INT.G_MISS_ATTRIBUTE_IDS_TBL
32: , P_CONTROL_RECORD IN ASO_DEFAULTING_INT.Control_Rec_Type
33: := ASO_DEFAULTING_INT.G_MISS_CONTROL_REC
34: , X_DEPENDENT_RECORD OUT NOCOPY /* file.sql.39 change */ ASO_AK_QUOTE_HEADER_V%ROWTYPE
35: , X_RETURN_STATUS OUT NOCOPY /* file.sql.39 change */ VARCHAR2
36: , X_MSG_COUNT OUT NOCOPY /* file.sql.39 change */ NUMBER
37: , X_MSG_DATA OUT NOCOPY /* file.sql.39 change */ VARCHAR2