DBA Data[Home] [Help]

APPS.CSC_ACTION_ASSEMBLER_PVT dependencies on OKC_AQ_PVT

Line 55: p_Msg_Tbl IN OKC_AQ_PVT.MSG_TAB_TYP,

51: END ENABLE_PLAN;
52:
53: /*
54: PROCEDURE CHECK_ACTION_ATTRIBUTES (p_Action_id NUMBER,
55: p_Msg_Tbl IN OKC_AQ_PVT.MSG_TAB_TYP,
56: x_Action_attr_tbl OUT NOCOPY OKC_AQ_PVT.MSG_TAB_TYP)
57: IS
58: Cursor C1 is
59: SELECT element_name

Line 56: x_Action_attr_tbl OUT NOCOPY OKC_AQ_PVT.MSG_TAB_TYP)

52:
53: /*
54: PROCEDURE CHECK_ACTION_ATTRIBUTES (p_Action_id NUMBER,
55: p_Msg_Tbl IN OKC_AQ_PVT.MSG_TAB_TYP,
56: x_Action_attr_tbl OUT NOCOPY OKC_AQ_PVT.MSG_TAB_TYP)
57: IS
58: Cursor C1 is
59: SELECT element_name
60: FROM okc_action_attributes_v

Line 77: x_Action_Attr_tbl := okc_aq_pvt.msg_tab_typ();

73: FOR C1_rec in C1 LOOP
74: l_no_of_rows := l_no_of_rows + 1;
75: l_Element_Name_Tbl(l_no_of_rows).Element_Name := C1_rec.Element_Name;
76: END LOOP;
77: x_Action_Attr_tbl := okc_aq_pvt.msg_tab_typ();
78: IF p_Msg_Tbl.count > 0
79: THEN
80: FOR i in p_Msg_tbl.FIRST..p_Msg_Tbl.LAST LOOP
81: FOR j in 1..l_Element_Name_tbl.COUNT LOOP

Line 100: P_Msg_Tbl IN OKC_AQ_PVT.MSG_TAB_TYP,

96: P_PARTY_ID IN NUMBER,
97: P_Cust_Account_Id IN NUMBER,
98: P_End_User_Type IN VARCHAR2 := NULL,
99: P_Application_Short_Name IN VARCHAR2,
100: P_Msg_Tbl IN OKC_AQ_PVT.MSG_TAB_TYP,
101: X_Results_Tbl OUT NOCOPY RESULTS_TAB_TYPE )
102: IS
103: x_return_status varchar2(1);
104: x_msg_count number;

Line 141: P_Msg_Tbl IN OKC_AQ_PVT.MSG_TAB_TYP,

137: p_api_version_number IN NUMBER,
138: p_init_msg_list IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
139: P_Condition_Id IN okc_condition_headers_b.id%TYPE,
140: P_Application_short_name IN VARCHAR2,
141: P_Msg_Tbl IN OKC_AQ_PVT.MSG_TAB_TYP,
142: x_return_status OUT NOCOPY VARCHAR2,
143: x_msg_count OUT NOCOPY NUMBER,
144: x_msg_data OUT NOCOPY VARCHAR2,
145: X_Results_Tbl IN OUT NOCOPY RESULTS_TAB_TYPE )

Line 151: l_MSG_REC OKC_AQ_PVT.MSG_REC_TYP;

147: --local variables
148: l_OUTCOME_TBL OKC_CONDITION_EVAL_PUB.OUTCOME_TAB_TYPE ;
149: l_RESULTS_TBL RESULTS_TAB_TYPE ;
150:
151: l_MSG_REC OKC_AQ_PVT.MSG_REC_TYP;
152: l_MSG_TBL OKC_AQ_PVT.MSG_TAB_TYP ;
153:
154: l_param_tbl params_tab_type;
155: l_Name VARCHAR2(1000);

Line 152: l_MSG_TBL OKC_AQ_PVT.MSG_TAB_TYP ;

148: l_OUTCOME_TBL OKC_CONDITION_EVAL_PUB.OUTCOME_TAB_TYPE ;
149: l_RESULTS_TBL RESULTS_TAB_TYPE ;
150:
151: l_MSG_REC OKC_AQ_PVT.MSG_REC_TYP;
152: l_MSG_TBL OKC_AQ_PVT.MSG_TAB_TYP ;
153:
154: l_param_tbl params_tab_type;
155: l_Name VARCHAR2(1000);
156: l_Description VARCHAR2(1800);