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