eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_PAYMENTMANAGERDB_PKG dependencies on IBY_BEPINFO

Line 41: x_bepid_out OUT NOCOPY iby_BEPInfo.BEPID%TYPE,

37: px_bep_lang_in_out IN OUT NOCOPY VARCHAR2,
38: x_payee_username_out OUT NOCOPY iby_payee.Username%TYPE,
39: x_payee_passwd_out OUT NOCOPY iby_payee.Password%TYPE,
40: x_payee_operation_out OUT NOCOPY NUMBER,
41: x_bepid_out OUT NOCOPY iby_BEPInfo.BEPID%TYPE,
42: x_bep_suffix_out OUT NOCOPY IBY_BEPInfo.Suffix%TYPE,
43: x_bep_url_out OUT NOCOPY IBY_BEPInfo.BaseURL%TYPE,
44: x_bep_key_out OUT NOCOPY IBY_BEPKeys.Key%TYPE,
45: x_bep_pmtscheme_out OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,

Line 42: x_bep_suffix_out OUT NOCOPY IBY_BEPInfo.Suffix%TYPE,

38: x_payee_username_out OUT NOCOPY iby_payee.Username%TYPE,
39: x_payee_passwd_out OUT NOCOPY iby_payee.Password%TYPE,
40: x_payee_operation_out OUT NOCOPY NUMBER,
41: x_bepid_out OUT NOCOPY iby_BEPInfo.BEPID%TYPE,
42: x_bep_suffix_out OUT NOCOPY IBY_BEPInfo.Suffix%TYPE,
43: x_bep_url_out OUT NOCOPY IBY_BEPInfo.BaseURL%TYPE,
44: x_bep_key_out OUT NOCOPY IBY_BEPKeys.Key%TYPE,
45: x_bep_pmtscheme_out OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,
46: x_bep_username_out OUT NOCOPY IBY_BEPInfo.BEPUsername%TYPE,

Line 43: x_bep_url_out OUT NOCOPY IBY_BEPInfo.BaseURL%TYPE,

39: x_payee_passwd_out OUT NOCOPY iby_payee.Password%TYPE,
40: x_payee_operation_out OUT NOCOPY NUMBER,
41: x_bepid_out OUT NOCOPY iby_BEPInfo.BEPID%TYPE,
42: x_bep_suffix_out OUT NOCOPY IBY_BEPInfo.Suffix%TYPE,
43: x_bep_url_out OUT NOCOPY IBY_BEPInfo.BaseURL%TYPE,
44: x_bep_key_out OUT NOCOPY IBY_BEPKeys.Key%TYPE,
45: x_bep_pmtscheme_out OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,
46: x_bep_username_out OUT NOCOPY IBY_BEPInfo.BEPUsername%TYPE,
47: x_bep_passwd_out OUT NOCOPY IBY_BEPInfo.BEPPassword%TYPE,

Line 46: x_bep_username_out OUT NOCOPY IBY_BEPInfo.BEPUsername%TYPE,

42: x_bep_suffix_out OUT NOCOPY IBY_BEPInfo.Suffix%TYPE,
43: x_bep_url_out OUT NOCOPY IBY_BEPInfo.BaseURL%TYPE,
44: x_bep_key_out OUT NOCOPY IBY_BEPKeys.Key%TYPE,
45: x_bep_pmtscheme_out OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,
46: x_bep_username_out OUT NOCOPY IBY_BEPInfo.BEPUsername%TYPE,
47: x_bep_passwd_out OUT NOCOPY IBY_BEPInfo.BEPPassword%TYPE,
48: x_security_out OUT NOCOPY NUMBER,
49: x_setnoinit_flag_out OUT NOCOPY NUMBER,
50: x_lead_time_out OUT NOCOPY iby_bepinfo.leadtime%TYPE,

Line 47: x_bep_passwd_out OUT NOCOPY IBY_BEPInfo.BEPPassword%TYPE,

43: x_bep_url_out OUT NOCOPY IBY_BEPInfo.BaseURL%TYPE,
44: x_bep_key_out OUT NOCOPY IBY_BEPKeys.Key%TYPE,
45: x_bep_pmtscheme_out OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,
46: x_bep_username_out OUT NOCOPY IBY_BEPInfo.BEPUsername%TYPE,
47: x_bep_passwd_out OUT NOCOPY IBY_BEPInfo.BEPPassword%TYPE,
48: x_security_out OUT NOCOPY NUMBER,
49: x_setnoinit_flag_out OUT NOCOPY NUMBER,
50: x_lead_time_out OUT NOCOPY iby_bepinfo.leadtime%TYPE,
51: x_bep_type_out OUT NOCOPY IBY_BEPInfo.Bep_Type%TYPE,

Line 50: x_lead_time_out OUT NOCOPY iby_bepinfo.leadtime%TYPE,

46: x_bep_username_out OUT NOCOPY IBY_BEPInfo.BEPUsername%TYPE,
47: x_bep_passwd_out OUT NOCOPY IBY_BEPInfo.BEPPassword%TYPE,
48: x_security_out OUT NOCOPY NUMBER,
49: x_setnoinit_flag_out OUT NOCOPY NUMBER,
50: x_lead_time_out OUT NOCOPY iby_bepinfo.leadtime%TYPE,
51: x_bep_type_out OUT NOCOPY IBY_BEPInfo.Bep_Type%TYPE,
52: x_fndcpt_user_profile_code_out OUT NOCOPY
53: IBY_FNDCPT_USER_CC_PF_VL.USER_CC_PROFILE_CODE%TYPE
54: )

Line 51: x_bep_type_out OUT NOCOPY IBY_BEPInfo.Bep_Type%TYPE,

47: x_bep_passwd_out OUT NOCOPY IBY_BEPInfo.BEPPassword%TYPE,
48: x_security_out OUT NOCOPY NUMBER,
49: x_setnoinit_flag_out OUT NOCOPY NUMBER,
50: x_lead_time_out OUT NOCOPY iby_bepinfo.leadtime%TYPE,
51: x_bep_type_out OUT NOCOPY IBY_BEPInfo.Bep_Type%TYPE,
52: x_fndcpt_user_profile_code_out OUT NOCOPY
53: IBY_FNDCPT_USER_CC_PF_VL.USER_CC_PROFILE_CODE%TYPE
54: )
55: IS

Line 128: x_bepid_out OUT NOCOPY iby_BEPInfo.BEPID%TYPE,

124: px_bep_lang_in_out IN OUT NOCOPY VARCHAR2,
125: x_payee_username_out OUT NOCOPY iby_payee.Username%TYPE,
126: x_payee_passwd_out OUT NOCOPY iby_payee.Password%TYPE,
127: x_payee_operation_out OUT NOCOPY NUMBER,
128: x_bepid_out OUT NOCOPY iby_BEPInfo.BEPID%TYPE,
129: x_bep_suffix_out OUT NOCOPY IBY_BEPInfo.Suffix%TYPE,
130: x_bep_url_out OUT NOCOPY IBY_BEPInfo.BaseURL%TYPE,
131: x_bep_key_out OUT NOCOPY IBY_BEPKeys.Key%TYPE,
132: x_bep_pmtscheme_out OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,

Line 129: x_bep_suffix_out OUT NOCOPY IBY_BEPInfo.Suffix%TYPE,

125: x_payee_username_out OUT NOCOPY iby_payee.Username%TYPE,
126: x_payee_passwd_out OUT NOCOPY iby_payee.Password%TYPE,
127: x_payee_operation_out OUT NOCOPY NUMBER,
128: x_bepid_out OUT NOCOPY iby_BEPInfo.BEPID%TYPE,
129: x_bep_suffix_out OUT NOCOPY IBY_BEPInfo.Suffix%TYPE,
130: x_bep_url_out OUT NOCOPY IBY_BEPInfo.BaseURL%TYPE,
131: x_bep_key_out OUT NOCOPY IBY_BEPKeys.Key%TYPE,
132: x_bep_pmtscheme_out OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,
133: x_bep_username_out OUT NOCOPY IBY_BEPInfo.BEPUsername%TYPE,

Line 130: x_bep_url_out OUT NOCOPY IBY_BEPInfo.BaseURL%TYPE,

126: x_payee_passwd_out OUT NOCOPY iby_payee.Password%TYPE,
127: x_payee_operation_out OUT NOCOPY NUMBER,
128: x_bepid_out OUT NOCOPY iby_BEPInfo.BEPID%TYPE,
129: x_bep_suffix_out OUT NOCOPY IBY_BEPInfo.Suffix%TYPE,
130: x_bep_url_out OUT NOCOPY IBY_BEPInfo.BaseURL%TYPE,
131: x_bep_key_out OUT NOCOPY IBY_BEPKeys.Key%TYPE,
132: x_bep_pmtscheme_out OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,
133: x_bep_username_out OUT NOCOPY IBY_BEPInfo.BEPUsername%TYPE,
134: x_bep_passwd_out OUT NOCOPY IBY_BEPInfo.BEPPassword%TYPE,

Line 133: x_bep_username_out OUT NOCOPY IBY_BEPInfo.BEPUsername%TYPE,

129: x_bep_suffix_out OUT NOCOPY IBY_BEPInfo.Suffix%TYPE,
130: x_bep_url_out OUT NOCOPY IBY_BEPInfo.BaseURL%TYPE,
131: x_bep_key_out OUT NOCOPY IBY_BEPKeys.Key%TYPE,
132: x_bep_pmtscheme_out OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,
133: x_bep_username_out OUT NOCOPY IBY_BEPInfo.BEPUsername%TYPE,
134: x_bep_passwd_out OUT NOCOPY IBY_BEPInfo.BEPPassword%TYPE,
135: x_security_out OUT NOCOPY NUMBER,
136: x_setnoinit_flag_out OUT NOCOPY NUMBER,
137: x_lead_time_out OUT NOCOPY iby_bepinfo.leadtime%TYPE,

Line 134: x_bep_passwd_out OUT NOCOPY IBY_BEPInfo.BEPPassword%TYPE,

130: x_bep_url_out OUT NOCOPY IBY_BEPInfo.BaseURL%TYPE,
131: x_bep_key_out OUT NOCOPY IBY_BEPKeys.Key%TYPE,
132: x_bep_pmtscheme_out OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,
133: x_bep_username_out OUT NOCOPY IBY_BEPInfo.BEPUsername%TYPE,
134: x_bep_passwd_out OUT NOCOPY IBY_BEPInfo.BEPPassword%TYPE,
135: x_security_out OUT NOCOPY NUMBER,
136: x_setnoinit_flag_out OUT NOCOPY NUMBER,
137: x_lead_time_out OUT NOCOPY iby_bepinfo.leadtime%TYPE,
138: x_bep_type_out OUT NOCOPY IBY_BEPInfo.Bep_Type%TYPE,

Line 137: x_lead_time_out OUT NOCOPY iby_bepinfo.leadtime%TYPE,

133: x_bep_username_out OUT NOCOPY IBY_BEPInfo.BEPUsername%TYPE,
134: x_bep_passwd_out OUT NOCOPY IBY_BEPInfo.BEPPassword%TYPE,
135: x_security_out OUT NOCOPY NUMBER,
136: x_setnoinit_flag_out OUT NOCOPY NUMBER,
137: x_lead_time_out OUT NOCOPY iby_bepinfo.leadtime%TYPE,
138: x_bep_type_out OUT NOCOPY IBY_BEPInfo.Bep_Type%TYPE,
139: x_fndcpt_user_profile_code_out OUT NOCOPY
140: IBY_FNDCPT_USER_CC_PF_VL.USER_CC_PROFILE_CODE%TYPE
141: )

Line 138: x_bep_type_out OUT NOCOPY IBY_BEPInfo.Bep_Type%TYPE,

134: x_bep_passwd_out OUT NOCOPY IBY_BEPInfo.BEPPassword%TYPE,
135: x_security_out OUT NOCOPY NUMBER,
136: x_setnoinit_flag_out OUT NOCOPY NUMBER,
137: x_lead_time_out OUT NOCOPY iby_bepinfo.leadtime%TYPE,
138: x_bep_type_out OUT NOCOPY IBY_BEPInfo.Bep_Type%TYPE,
139: x_fndcpt_user_profile_code_out OUT NOCOPY
140: IBY_FNDCPT_USER_CC_PF_VL.USER_CC_PROFILE_CODE%TYPE
141: )
142: IS

Line 147: l_base_url iby_bepinfo.baseurl%TYPE;

143: l_api_name CONSTANT VARCHAR2(30) := 'listbep';
144: l_module_name CONSTANT VARCHAR2(200) := G_DEBUG_MODULE || '.' ||
145: l_api_name;
146: l_bepid iby_default_bep.bepid%TYPE;
147: l_base_url iby_bepinfo.baseurl%TYPE;
148: l_pay_op VARCHAR2(100);
149: l_routing_fields RoutingAPIFields_rec_type;
150:
151: l_currency VARCHAR2(15);

Line 155: l_bepname iby_bepinfo.name%type;

151: l_currency VARCHAR2(15);
152: l_position NUMBER;
153:
154: l_payeename iby_payee.name%type;
155: l_bepname iby_bepinfo.name%type;
156:
157: -- *** R12 Modification *** ---
158: -- Added variables l_instr_type and l_mpayeeid
159: l_instr_type iby_trxn_summaries_all.instrtype%TYPE;

Line 284: SELECT b.name INTO l_bepname FROM iby_bepinfo b

280: IF ( x_bep_key_out IS NULL) THEN
281: -- Default BEP Key has not been configured
282: SELECT p.name INTO l_payeename FROM iby_payee p
283: WHERE px_payee_id_in_out = p.payeeid;
284: SELECT b.name INTO l_bepname FROM iby_bepinfo b
285: WHERE x_bepid_out = b.bepid;
286: raise_application_error(-20000, 'IBY_25002#PAYEENAME='
287: || l_payeename || '#BEPNAME='
288: || l_bepname || '#', FALSE);

Line 457: px_bep_suffix_in_out IN OUT NOCOPY iby_bepinfo.Suffix%TYPE,

453: PROCEDURE listbep (
454: p_payee_id IN iby_bepkeys.OwnerId%TYPE,
455: p_bepkey IN iby_bepkeys.KEY%TYPE,
456: p_instr_type IN iby_trxn_summaries_all.InstrType%TYPE,
457: px_bep_suffix_in_out IN OUT NOCOPY iby_bepinfo.Suffix%TYPE,
458: x_bepid_out OUT NOCOPY iby_bepinfo.BepId%TYPE,
459: x_bep_url_out OUT NOCOPY iby_bepinfo.BaseUrl%TYPE,
460: x_bep_pmtscheme_out OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,
461: x_bep_username_out OUT NOCOPY iby_bepinfo.BEPUsername%TYPE,

Line 458: x_bepid_out OUT NOCOPY iby_bepinfo.BepId%TYPE,

454: p_payee_id IN iby_bepkeys.OwnerId%TYPE,
455: p_bepkey IN iby_bepkeys.KEY%TYPE,
456: p_instr_type IN iby_trxn_summaries_all.InstrType%TYPE,
457: px_bep_suffix_in_out IN OUT NOCOPY iby_bepinfo.Suffix%TYPE,
458: x_bepid_out OUT NOCOPY iby_bepinfo.BepId%TYPE,
459: x_bep_url_out OUT NOCOPY iby_bepinfo.BaseUrl%TYPE,
460: x_bep_pmtscheme_out OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,
461: x_bep_username_out OUT NOCOPY iby_bepinfo.BEPUsername%TYPE,
462: x_bep_passwd_out OUT NOCOPY iby_bepinfo.BEPPassword%TYPE,

Line 459: x_bep_url_out OUT NOCOPY iby_bepinfo.BaseUrl%TYPE,

455: p_bepkey IN iby_bepkeys.KEY%TYPE,
456: p_instr_type IN iby_trxn_summaries_all.InstrType%TYPE,
457: px_bep_suffix_in_out IN OUT NOCOPY iby_bepinfo.Suffix%TYPE,
458: x_bepid_out OUT NOCOPY iby_bepinfo.BepId%TYPE,
459: x_bep_url_out OUT NOCOPY iby_bepinfo.BaseUrl%TYPE,
460: x_bep_pmtscheme_out OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,
461: x_bep_username_out OUT NOCOPY iby_bepinfo.BEPUsername%TYPE,
462: x_bep_passwd_out OUT NOCOPY iby_bepinfo.BEPPassword%TYPE,
463: x_security_out OUT NOCOPY NUMBER,

Line 461: x_bep_username_out OUT NOCOPY iby_bepinfo.BEPUsername%TYPE,

457: px_bep_suffix_in_out IN OUT NOCOPY iby_bepinfo.Suffix%TYPE,
458: x_bepid_out OUT NOCOPY iby_bepinfo.BepId%TYPE,
459: x_bep_url_out OUT NOCOPY iby_bepinfo.BaseUrl%TYPE,
460: x_bep_pmtscheme_out OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,
461: x_bep_username_out OUT NOCOPY iby_bepinfo.BEPUsername%TYPE,
462: x_bep_passwd_out OUT NOCOPY iby_bepinfo.BEPPassword%TYPE,
463: x_security_out OUT NOCOPY NUMBER,
464: x_setnoinit_flag_out OUT NOCOPY NUMBER,
465: x_bep_type_out OUT NOCOPY iby_bepinfo.Bep_Type%TYPE,

Line 462: x_bep_passwd_out OUT NOCOPY iby_bepinfo.BEPPassword%TYPE,

458: x_bepid_out OUT NOCOPY iby_bepinfo.BepId%TYPE,
459: x_bep_url_out OUT NOCOPY iby_bepinfo.BaseUrl%TYPE,
460: x_bep_pmtscheme_out OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,
461: x_bep_username_out OUT NOCOPY iby_bepinfo.BEPUsername%TYPE,
462: x_bep_passwd_out OUT NOCOPY iby_bepinfo.BEPPassword%TYPE,
463: x_security_out OUT NOCOPY NUMBER,
464: x_setnoinit_flag_out OUT NOCOPY NUMBER,
465: x_bep_type_out OUT NOCOPY iby_bepinfo.Bep_Type%TYPE,
466: x_bep_lang_out OUT NOCOPY VARCHAR2,

Line 465: x_bep_type_out OUT NOCOPY iby_bepinfo.Bep_Type%TYPE,

461: x_bep_username_out OUT NOCOPY iby_bepinfo.BEPUsername%TYPE,
462: x_bep_passwd_out OUT NOCOPY iby_bepinfo.BEPPassword%TYPE,
463: x_security_out OUT NOCOPY NUMBER,
464: x_setnoinit_flag_out OUT NOCOPY NUMBER,
465: x_bep_type_out OUT NOCOPY iby_bepinfo.Bep_Type%TYPE,
466: x_bep_lang_out OUT NOCOPY VARCHAR2,
467: x_lead_time_out OUT NOCOPY iby_bepinfo.leadtime%TYPE
468: )
469: IS

Line 467: x_lead_time_out OUT NOCOPY iby_bepinfo.leadtime%TYPE

463: x_security_out OUT NOCOPY NUMBER,
464: x_setnoinit_flag_out OUT NOCOPY NUMBER,
465: x_bep_type_out OUT NOCOPY iby_bepinfo.Bep_Type%TYPE,
466: x_bep_lang_out OUT NOCOPY VARCHAR2,
467: x_lead_time_out OUT NOCOPY iby_bepinfo.leadtime%TYPE
468: )
469: IS
470: l_op_type iby_trxn_summaries_all.reqtype%TYPE;
471: l_base_url IBY_BEPInfo.BaseURL%TYPE;

Line 471: l_base_url IBY_BEPInfo.BaseURL%TYPE;

467: x_lead_time_out OUT NOCOPY iby_bepinfo.leadtime%TYPE
468: )
469: IS
470: l_op_type iby_trxn_summaries_all.reqtype%TYPE;
471: l_base_url IBY_BEPInfo.BaseURL%TYPE;
472: l_key_count NUMBER;
473:
474: BEGIN
475: getBepBySuffix(px_bep_suffix_in_out,x_bepid_out,l_base_url,x_bep_pmtscheme_out,p_instr_type);

Line 880: (i_suffix IN IBY_BEPInfo.Suffix%TYPE,

876:
877: /* Internal procedure that gets the bep configuration by */
878: /* bep suffix. */
879: PROCEDURE getBepBySuffix
880: (i_suffix IN IBY_BEPInfo.Suffix%TYPE,
881: o_bepid OUT NOCOPY IBY_BEPInfo.BEPID%TYPE,
882: o_bep_base_url OUT NOCOPY IBY_BEPInfo.BaseURL%TYPE,
883: o_pmtschemename OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,
884: i_instrtype IN iby_accttype.instrtype%type )

Line 881: o_bepid OUT NOCOPY IBY_BEPInfo.BEPID%TYPE,

877: /* Internal procedure that gets the bep configuration by */
878: /* bep suffix. */
879: PROCEDURE getBepBySuffix
880: (i_suffix IN IBY_BEPInfo.Suffix%TYPE,
881: o_bepid OUT NOCOPY IBY_BEPInfo.BEPID%TYPE,
882: o_bep_base_url OUT NOCOPY IBY_BEPInfo.BaseURL%TYPE,
883: o_pmtschemename OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,
884: i_instrtype IN iby_accttype.instrtype%type )
885: IS

Line 882: o_bep_base_url OUT NOCOPY IBY_BEPInfo.BaseURL%TYPE,

878: /* bep suffix. */
879: PROCEDURE getBepBySuffix
880: (i_suffix IN IBY_BEPInfo.Suffix%TYPE,
881: o_bepid OUT NOCOPY IBY_BEPInfo.BEPID%TYPE,
882: o_bep_base_url OUT NOCOPY IBY_BEPInfo.BaseURL%TYPE,
883: o_pmtschemename OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,
884: i_instrtype IN iby_accttype.instrtype%type )
885: IS
886:

Line 892: FROM iby_bepinfo

888:
889: -- Get bep info
890: SELECT bepid , baseurl
891: INTO o_bepid, o_bep_base_url
892: FROM iby_bepinfo
893: WHERE suffix = i_suffix;
894:
895: -- Get payment scheme name
896: getPmtSchemeName(o_bepid, i_instrtype, o_pmtschemename);

Line 901: -- Suffix not found in IBY_BEPINFO table

897:
898: EXCEPTION
899:
900: WHEN NO_DATA_FOUND THEN
901: -- Suffix not found in IBY_BEPINFO table
902: IF (o_bepid IS NULL) THEN
903: raise_application_error(-20000, 'IBY_20361#', FALSE);
904: END IF;
905:

Line 1003: procedure getBEPLang(i_bepid IN iby_bepinfo.bepid%type,

999:
1000: /* Procedure: getBEPLang
1001: * Function: fetch valid nlslang based on input lang
1002: */
1003: procedure getBEPLang(i_bepid IN iby_bepinfo.bepid%type,
1004: io_beplang IN OUT NOCOPY iby_beplangs.beplang%type)
1005: IS
1006: CURSOR c_getPreferred(ci_bepid iby_bepinfo.bepid%type) IS
1007: SELECT beplang

Line 1006: CURSOR c_getPreferred(ci_bepid iby_bepinfo.bepid%type) IS

1002: */
1003: procedure getBEPLang(i_bepid IN iby_bepinfo.bepid%type,
1004: io_beplang IN OUT NOCOPY iby_beplangs.beplang%type)
1005: IS
1006: CURSOR c_getPreferred(ci_bepid iby_bepinfo.bepid%type) IS
1007: SELECT beplang
1008: FROM iby_BEPlangs
1009: WHERE BEPID = ci_bepid
1010: AND Preferred = 0

Line 1056: FUNCTION getNLSLang(i_bepid IN iby_bepinfo.bepid%type,

1052: * statement to specify the NLSLANG.
1053: */
1054: /* comment out for now */
1055: /*
1056: FUNCTION getNLSLang(i_bepid IN iby_bepinfo.bepid%type,
1057: i_beplang IN iby_beplangs.beplang%type) RETURN VARCHAR2 IS
1058: v_Lang iby_beplangs.beplang%type;
1059: BEGIN
1060: v_Lang := i_beplang;

Line 1068: PROCEDURE getPmtSchemeName(i_bepid IN iby_bepinfo.bepid%type,

1064: */
1065:
1066:
1067: -- Get payment scheme name for given bep based on instrtype
1068: PROCEDURE getPmtSchemeName(i_bepid IN iby_bepinfo.bepid%type,
1069: i_instrtype IN iby_accttype.instrtype%type,
1070: o_pmtschemename OUT NOCOPY
1071: iby_pmtschemes.pmtschemename%type)
1072: IS

Line 1078: CURSOR c_getPmtSchemeName(ci_bepid iby_bepinfo.bepid%type,

1074: l_scheme_not_found BOOLEAN := TRUE;
1075: l_bankpay_bep VARCHAR2(10);
1076: l_trxn_bep VARCHAR2(10);
1077:
1078: CURSOR c_getPmtSchemeName(ci_bepid iby_bepinfo.bepid%type,
1079: ci_name1 iby_pmtschemes.pmtschemename%type,
1080: ci_name2 iby_pmtschemes.pmtschemename%type DEFAULT NULL,
1081: ci_name3 iby_pmtschemes.pmtschemename%type DEFAULT NULL)
1082: IS

Line 1084: FROM iby_pmtschemes p, iby_bepinfo b

1080: ci_name2 iby_pmtschemes.pmtschemename%type DEFAULT NULL,
1081: ci_name3 iby_pmtschemes.pmtschemename%type DEFAULT NULL)
1082: IS
1083: SELECT p.PmtSchemename
1084: FROM iby_pmtschemes p, iby_bepinfo b
1085: WHERE p.bepid = b.bepid
1086: AND b.bepid = ci_bepid
1087: AND p.PMTSCHEMENAME IN (ci_name1, ci_name2, ci_name3);
1088:

Line 1112: --FROM iby_bepinfo

1108: -- by now to point to an existing BEP
1109: --
1110: --SELECT suffix
1111: --INTO l_trxn_bep
1112: --FROM iby_bepinfo
1113: --WHERE (bepid=i_bepid);
1114: --l_scheme_not_found := l_trxn_bep <> NVL(l_bankpay_bep,'');
1115: --ELSE
1116: -- Change 'CREDITCARD' to 'SSL' and 'SET' for payment scheme

Line 1146: PROCEDURE getBepUrl(i_base_url IN iby_bepinfo.baseurl%type,

1142:
1143: END getPmtSchemeName;
1144:
1145:
1146: PROCEDURE getBepUrl(i_base_url IN iby_bepinfo.baseurl%type,
1147: i_payment_op IN VARCHAR2,
1148: i_pmtschemename IN iby_pmtschemes.pmtschemename%type,
1149: i_suffix IN iby_bepinfo.suffix%type,
1150: o_bep_url OUT NOCOPY VARCHAR2)

Line 1149: i_suffix IN iby_bepinfo.suffix%type,

1145:
1146: PROCEDURE getBepUrl(i_base_url IN iby_bepinfo.baseurl%type,
1147: i_payment_op IN VARCHAR2,
1148: i_pmtschemename IN iby_pmtschemes.pmtschemename%type,
1149: i_suffix IN iby_bepinfo.suffix%type,
1150: o_bep_url OUT NOCOPY VARCHAR2)
1151: IS
1152: BEGIN
1153: IF (i_pmtschemename = 'SSL' OR i_pmtschemename = 'PURCHASECARD' OR

Line 1176: o_bepid OUT NOCOPY iby_bepinfo.bepid%type,

1172: END getBepUrl;
1173:
1174: PROCEDURE getBepIdByPmtName(i_paymentmethodname IN VARCHAR2,
1175: i_payeeid IN iby_payee.payeeid%type,
1176: o_bepid OUT NOCOPY iby_bepinfo.bepid%type,
1177: o_bepkey OUT NOCOPY iby_bepkeys.key%type,
1178: o_fc_user_profile_code IN OUT NOCOPY VARCHAR2)
1179: IS
1180: CURSOR c_getBepIdByPmtName(ci_paymentmethodname VARCHAR2)

Line 1183: FROM iby_routinginfo r, iby_bepinfo b

1179: IS
1180: CURSOR c_getBepIdByPmtName(ci_paymentmethodname VARCHAR2)
1181: IS
1182: SELECT b.bepid, r.bepkey, r.fndcpt_user_profile_code
1183: FROM iby_routinginfo r, iby_bepinfo b
1184: WHERE r.paymentmethodname = ci_paymentmethodname
1185: AND r.configured = 1
1186: AND r.bepid = b.bepid;
1187:

Line 1208: o_bepid OUT NOCOPY iby_bepinfo.bepid%type,

1204: END getBepIdByPmtName;
1205:
1206: PROCEDURE getDefaultBepId(i_mpayeeid IN iby_payee.mpayeeid%type,
1207: i_payment_channel_code IN iby_trxn_summaries_all.payment_channel_code%type,
1208: o_bepid OUT NOCOPY iby_bepinfo.bepid%type,
1209: o_bepkey OUT NOCOPY iby_bepkeys.key%type,
1210: o_fndcpt_user_profile_code OUT NOCOPY
1211: IBY_FNDCPT_USER_CC_PF_VL.USER_CC_PROFILE_CODE%TYPE)
1212: IS

Line 1222: FROM iby_default_bep a, iby_bepinfo b, iby_bepkeys c

1218: IS
1219: SELECT a.bepid,
1220: c.key,
1221: a.fndcpt_user_profile_code
1222: FROM iby_default_bep a, iby_bepinfo b, iby_bepkeys c
1223: WHERE a.payment_channel_code = ci_payment_channel_code
1224: AND a.mpayeeid = ci_mpayeeid
1225: AND a.bepid = b.bepid
1226: AND UPPER(b.activeStatus) = 'Y'

Line 1243: PROCEDURE getBepById(i_bepid IN iby_bepinfo.bepid%type,

1239:
1240: END getDefaultBepId;
1241:
1242:
1243: PROCEDURE getBepById(i_bepid IN iby_bepinfo.bepid%type,
1244: o_suffix OUT NOCOPY iby_bepinfo.suffix%type,
1245: o_baseurl OUT NOCOPY iby_bepinfo.baseurl%type,
1246: o_securityscheme OUT NOCOPY iby_bepinfo.securityscheme%type,
1247: o_bepusername OUT NOCOPY iby_bepinfo.bepusername%type,

Line 1244: o_suffix OUT NOCOPY iby_bepinfo.suffix%type,

1240: END getDefaultBepId;
1241:
1242:
1243: PROCEDURE getBepById(i_bepid IN iby_bepinfo.bepid%type,
1244: o_suffix OUT NOCOPY iby_bepinfo.suffix%type,
1245: o_baseurl OUT NOCOPY iby_bepinfo.baseurl%type,
1246: o_securityscheme OUT NOCOPY iby_bepinfo.securityscheme%type,
1247: o_bepusername OUT NOCOPY iby_bepinfo.bepusername%type,
1248: o_beppassword OUT NOCOPY iby_bepinfo.beppassword%type,

Line 1245: o_baseurl OUT NOCOPY iby_bepinfo.baseurl%type,

1241:
1242:
1243: PROCEDURE getBepById(i_bepid IN iby_bepinfo.bepid%type,
1244: o_suffix OUT NOCOPY iby_bepinfo.suffix%type,
1245: o_baseurl OUT NOCOPY iby_bepinfo.baseurl%type,
1246: o_securityscheme OUT NOCOPY iby_bepinfo.securityscheme%type,
1247: o_bepusername OUT NOCOPY iby_bepinfo.bepusername%type,
1248: o_beppassword OUT NOCOPY iby_bepinfo.beppassword%type,
1249: o_beptype OUT NOCOPY iby_bepinfo.bep_type%TYPE,

Line 1246: o_securityscheme OUT NOCOPY iby_bepinfo.securityscheme%type,

1242:
1243: PROCEDURE getBepById(i_bepid IN iby_bepinfo.bepid%type,
1244: o_suffix OUT NOCOPY iby_bepinfo.suffix%type,
1245: o_baseurl OUT NOCOPY iby_bepinfo.baseurl%type,
1246: o_securityscheme OUT NOCOPY iby_bepinfo.securityscheme%type,
1247: o_bepusername OUT NOCOPY iby_bepinfo.bepusername%type,
1248: o_beppassword OUT NOCOPY iby_bepinfo.beppassword%type,
1249: o_beptype OUT NOCOPY iby_bepinfo.bep_type%TYPE,
1250: o_leadtime OUT NOCOPY iby_bepinfo.leadtime%TYPE)

Line 1247: o_bepusername OUT NOCOPY iby_bepinfo.bepusername%type,

1243: PROCEDURE getBepById(i_bepid IN iby_bepinfo.bepid%type,
1244: o_suffix OUT NOCOPY iby_bepinfo.suffix%type,
1245: o_baseurl OUT NOCOPY iby_bepinfo.baseurl%type,
1246: o_securityscheme OUT NOCOPY iby_bepinfo.securityscheme%type,
1247: o_bepusername OUT NOCOPY iby_bepinfo.bepusername%type,
1248: o_beppassword OUT NOCOPY iby_bepinfo.beppassword%type,
1249: o_beptype OUT NOCOPY iby_bepinfo.bep_type%TYPE,
1250: o_leadtime OUT NOCOPY iby_bepinfo.leadtime%TYPE)
1251: IS

Line 1248: o_beppassword OUT NOCOPY iby_bepinfo.beppassword%type,

1244: o_suffix OUT NOCOPY iby_bepinfo.suffix%type,
1245: o_baseurl OUT NOCOPY iby_bepinfo.baseurl%type,
1246: o_securityscheme OUT NOCOPY iby_bepinfo.securityscheme%type,
1247: o_bepusername OUT NOCOPY iby_bepinfo.bepusername%type,
1248: o_beppassword OUT NOCOPY iby_bepinfo.beppassword%type,
1249: o_beptype OUT NOCOPY iby_bepinfo.bep_type%TYPE,
1250: o_leadtime OUT NOCOPY iby_bepinfo.leadtime%TYPE)
1251: IS
1252: CURSOR c_getBepById(ci_bepid iby_bepinfo.bepid%type)

Line 1249: o_beptype OUT NOCOPY iby_bepinfo.bep_type%TYPE,

1245: o_baseurl OUT NOCOPY iby_bepinfo.baseurl%type,
1246: o_securityscheme OUT NOCOPY iby_bepinfo.securityscheme%type,
1247: o_bepusername OUT NOCOPY iby_bepinfo.bepusername%type,
1248: o_beppassword OUT NOCOPY iby_bepinfo.beppassword%type,
1249: o_beptype OUT NOCOPY iby_bepinfo.bep_type%TYPE,
1250: o_leadtime OUT NOCOPY iby_bepinfo.leadtime%TYPE)
1251: IS
1252: CURSOR c_getBepById(ci_bepid iby_bepinfo.bepid%type)
1253: IS

Line 1250: o_leadtime OUT NOCOPY iby_bepinfo.leadtime%TYPE)

1246: o_securityscheme OUT NOCOPY iby_bepinfo.securityscheme%type,
1247: o_bepusername OUT NOCOPY iby_bepinfo.bepusername%type,
1248: o_beppassword OUT NOCOPY iby_bepinfo.beppassword%type,
1249: o_beptype OUT NOCOPY iby_bepinfo.bep_type%TYPE,
1250: o_leadtime OUT NOCOPY iby_bepinfo.leadtime%TYPE)
1251: IS
1252: CURSOR c_getBepById(ci_bepid iby_bepinfo.bepid%type)
1253: IS
1254: SELECT suffix, baseurl, securityscheme, BEPUsername, BEPPassword, bep_type, leadtime

Line 1252: CURSOR c_getBepById(ci_bepid iby_bepinfo.bepid%type)

1248: o_beppassword OUT NOCOPY iby_bepinfo.beppassword%type,
1249: o_beptype OUT NOCOPY iby_bepinfo.bep_type%TYPE,
1250: o_leadtime OUT NOCOPY iby_bepinfo.leadtime%TYPE)
1251: IS
1252: CURSOR c_getBepById(ci_bepid iby_bepinfo.bepid%type)
1253: IS
1254: SELECT suffix, baseurl, securityscheme, BEPUsername, BEPPassword, bep_type, leadtime
1255: FROM iby_bepinfo
1256: WHERE bepid = ci_bepid;

Line 1255: FROM iby_bepinfo

1251: IS
1252: CURSOR c_getBepById(ci_bepid iby_bepinfo.bepid%type)
1253: IS
1254: SELECT suffix, baseurl, securityscheme, BEPUsername, BEPPassword, bep_type, leadtime
1255: FROM iby_bepinfo
1256: WHERE bepid = ci_bepid;
1257:
1258: BEGIN
1259: IF (i_bepid = -1) THEN