[Home] [Help]
452: -- source line id has the fnd_user userid got thro ICX call
453: qri_source_line_id := icx_sec.getID(icx_sec.PV_USER_ID);
454:
455: if (txn_num = 100) THEN
456: qri_source_code := 'QA_SS_OSP';
457: elsif (txn_num = 110) THEN
458: qri_source_code := 'QA_SS_SHIP';
459: end if;
460:
1712: not_selfserve EXCEPTION;
1713: BEGIN
1714:
1715: If (Txn_Num = 100) Then -- OSP Txn
1716: qa_ss_osp.default_osp_values(Ctx, Txn_Num, PK1, PK2, PK3,
1717: PK4, PK5, PK6, PK7, PK8, PK9, PK10, X_Po_Agent_Id,
1718: X_Item_Id, X_Po_Header_Id, X_Wip_Entity_Type,
1719: X_Wip_Rep_Sch_Id, X_Po_Release_Id, X_Po_Line_Id,
1720: X_Line_Location_Id, X_Po_Distribution_Id, X_Wip_Entity_Id,
3353: -- anagarwa Thu Nov 8 11:24:34 PST 2001
3354: -- Following return added to handle following problem (Bug #2101177) :
3355: -- ORA-06503: PL/SQL: Function returned without value
3356: -- ORA-06512: at "APPS.QA_SS_CORE", line 3327
3357: -- ORA-06512: at "APPS.QA_SS_OSP", line 48
3358: -- ORA-06512: at line 1
3359: RETURN FALSE;
3360: END any_applicable_plans;
3361: ----------------------------------------------------------------------------------------
3554: -- anagarwa Thu Nov 8 11:24:34 PST 2001
3555: -- Following return added to handle following problem (Bug #2101177) :
3556: -- ORA-06503: PL/SQL: Function returned without value
3557: -- ORA-06512: at "APPS.QA_SS_CORE", line 3327
3558: -- ORA-06512: at "APPS.QA_SS_OSP", line 48
3559: -- ORA-06512: at line 1
3560: RETURN FALSE;
3561: END Evaluate_Triggers;
3562: ----------------------------------------------------------------------------------------------
3835:
3836: l_language_code := ICX_Sec.GetId(ICX_SEC.PV_LANGUAGE_CODE);
3837:
3838: IF (txn_num=100) then
3839: url_str :='qa_ss_osp.osp_plans';
3840: ELSIF (txn_num=110) then
3841: url_str := 'qa_ss_ship.shipping_plans';
3842: END IF;
3843: