DBA Data[Home] [Help]

APPS.QA_SS_OSP dependencies on QA_SS_CORE

Line 45: qa_ss_core.get_item_category_val(

41: Ctx(qa_ss_const.Ordered_Quantity) := to_char(P_Quantity_Ordered);
42: Ctx(qa_ss_const.Revision) := P_Item_Revision;
43: Ctx(qa_ss_const.PO_Release_Num) := to_char(P_Po_Release_Number);
44: Ctx(qa_ss_const.Organization_Id) := to_char(P_Organization_Id);
45: qa_ss_core.get_item_category_val(
46: p_org_id => p_organization_id,
47: p_item_val => p_item_number,
48: x_category_val => p_category,
49: x_category_id => p_category_id);

Line 57: IF ( qa_ss_core.any_applicable_plans( Ctx, 100, P_Organization_Id))

53: -- P_Wip_entity_type can be used for any checking if needed
54:
55:
56:
57: IF ( qa_ss_core.any_applicable_plans( Ctx, 100, P_Organization_Id))
58: THEN
59: return 'Y'; -- there are applicable plans
60: ELSE
61: return 'N'; -- No plans

Line 98: qa_ss_core.plan_list_frames(100, pk1, pk2, pk3, pk4, pk5, pk6, pk7, pk8, pk9, pk10);

94:
95: BEGIN
96:
97: if (icx_sec.validateSession) then
98: qa_ss_core.plan_list_frames(100, pk1, pk2, pk3, pk4, pk5, pk6, pk7, pk8, pk9, pk10);
99: end if; -- end icx validate session
100:
101: EXCEPTION
102: WHEN OTHERS THEN

Line 239: -- Below procedure to be called from qa_ss_core.plan_list_frames

235: htp.p(SQLERRM);
236:
237: END default_osp_values;
238: ----------------------------------------------------------------------------------------------
239: -- Below procedure to be called from qa_ss_core.plan_list_frames
240: procedure osp_plans (
241: PK1 IN VARCHAR2 DEFAULT NULL,
242: PK2 IN VARCHAR2 DEFAULT NULL,
243: PK3 IN VARCHAR2 DEFAULT NULL,

Line 284: qa_ss_core.all_applicable_plans( Ctx, 100, P_Organization_Id, PK1, PK2,Pk3,

280:
281: CLOSE osp_cur;
282: -- Now Ctx is populated. Also, populated P_Organization_Id above
283:
284: qa_ss_core.all_applicable_plans( Ctx, 100, P_Organization_Id, PK1, PK2,Pk3,
285: Pk4,PK5,PK6,PK7,PK8,PK9,PK10);
286:
287: -- This is all we do here. all_applicable_plans will call necessary procedures
288: -- to take care from here onwards