APPS.AP_WEB_PCARD_WORKFLOW_PKG dependencies on ICX_CALL

Line 652: l_document_type varchar2(30) := icx_call.decrypt(p2);

648: p11 varchar2 Default NULL) IS
649: -------------------------------------
650: l_param varchar2(240);
651: c_rowid varchar2(20);
652: l_document_type varchar2(30) := icx_call.decrypt(p2);
653: l_session_id number;
654: --l_icx_application_id number := AP_WEB_INTERFACE_PKG.GetICXApplicationId;
655: l_application_id number := 200;
656: BEGIN

Line 680: l_param := 'D*****1****' || c_rowid || '*AP_CARD_NOTIFICATIONS_PK1*' || icx_call.decrypt(p1) || '**]';

676: AND TO_PAGE_APPL_ID = l_application_id
677: AND FLOW_CODE = 'AP_CARD_INQUIRIES'
678: AND FLOW_APPLICATION_ID = l_application_id;
679:
680: l_param := 'D*****1****' || c_rowid || '*AP_CARD_NOTIFICATIONS_PK1*' || icx_call.decrypt(p1) || '**]';
681:
682: -- l_param := 'W*200*AP_CARD_INQUIRIES*200*AP_EXP_FEED_DIST_OPEN*where employee_verification_id = ' || icx_call.decrypt(p1) || '**]';
683:
684: ELSIF (l_document_type = 'PCARD MANAGER APPR' ) THEN

Line 682: -- l_param := 'W*200*AP_CARD_INQUIRIES*200*AP_EXP_FEED_DIST_OPEN*where employee_verification_id = ' || icx_call.decrypt(p1) || '**]';

678: AND FLOW_APPLICATION_ID = l_application_id;
679:
680: l_param := 'D*****1****' || c_rowid || '*AP_CARD_NOTIFICATIONS_PK1*' || icx_call.decrypt(p1) || '**]';
681:
682: -- l_param := 'W*200*AP_CARD_INQUIRIES*200*AP_EXP_FEED_DIST_OPEN*where employee_verification_id = ' || icx_call.decrypt(p1) || '**]';
683:
684: ELSIF (l_document_type = 'PCARD MANAGER APPR' ) THEN
685:
686: SELECT rowidtochar(ROWID)

Line 698: -- l_param := 'D*****1****' || c_rowid || '*AP_EXP_FEED_DISTS_PK1*' || icx_call.decrypt(p1) || '**]';

694: AND TO_PAGE_APPL_ID = l_application_id
695: AND FLOW_CODE = 'AP_CARD_INQUIRIES'
696: AND FLOW_APPLICATION_ID = l_application_id;
697:
698: -- l_param := 'D*****1****' || c_rowid || '*AP_EXP_FEED_DISTS_PK1*' || icx_call.decrypt(p1) || '**]';
699:
700: l_param := 'D*****1****' || c_rowid || '*AP_CARD_NOTIFICATIONS_PK1*' || icx_call.decrypt(p1) || '**]';
701:
702: END IF;

Line 700: l_param := 'D*****1****' || c_rowid || '*AP_CARD_NOTIFICATIONS_PK1*' || icx_call.decrypt(p1) || '**]';

696: AND FLOW_APPLICATION_ID = l_application_id;
697:
698: -- l_param := 'D*****1****' || c_rowid || '*AP_EXP_FEED_DISTS_PK1*' || icx_call.decrypt(p1) || '**]';
699:
700: l_param := 'D*****1****' || c_rowid || '*AP_CARD_NOTIFICATIONS_PK1*' || icx_call.decrypt(p1) || '**]';
701:
702: END IF;
703:
704:

Line 706: OracleOn.IC(Y=>icx_call.encrypt2(l_param,-999));

702: END IF;
703:
704:
705: IF (l_session_id IS NULL) THEN
706: OracleOn.IC(Y=>icx_call.encrypt2(l_param,-999));
707: ELSE
708: OracleOn.IC(Y=>icx_call.encrypt2(l_param,l_session_id));
709: END IF;
710:

Line 708: OracleOn.IC(Y=>icx_call.encrypt2(l_param,l_session_id));

704:
705: IF (l_session_id IS NULL) THEN
706: OracleOn.IC(Y=>icx_call.encrypt2(l_param,-999));
707: ELSE
708: OracleOn.IC(Y=>icx_call.encrypt2(l_param,l_session_id));
709: END IF;
710:
711: END IF;
712: */