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 129: x_bepid_out OUT NOCOPY iby_BEPInfo.BEPID%TYPE,

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 149: l_base_url iby_bepinfo.baseurl%TYPE;

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

Line 157: l_bepname iby_bepinfo.name%type;

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

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

294: IF ( x_bep_key_out IS NULL) THEN
295: -- Default BEP Key has not been configured
296: SELECT p.name INTO l_payeename FROM iby_payee p
297: WHERE px_payee_id_in_out = p.payeeid;
298: SELECT b.name INTO l_bepname FROM iby_bepinfo b
299: WHERE x_bepid_out = b.bepid;
300: raise_application_error(-20000, 'IBY_25002#PAYEENAME='
301: || l_payeename || '#BEPNAME='
302: || l_bepname || '#', FALSE);

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

471: PROCEDURE listbep (
472: p_payee_id IN iby_bepkeys.OwnerId%TYPE,
473: p_bepkey IN iby_bepkeys.KEY%TYPE,
474: p_instr_type IN iby_trxn_summaries_all.InstrType%TYPE,
475: px_bep_suffix_in_out IN OUT NOCOPY iby_bepinfo.Suffix%TYPE,
476: x_bepid_out OUT NOCOPY iby_bepinfo.BepId%TYPE,
477: x_bep_url_out OUT NOCOPY iby_bepinfo.BaseUrl%TYPE,
478: x_bep_pmtscheme_out OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,
479: x_bep_username_out OUT NOCOPY iby_bepinfo.BEPUsername%TYPE,

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

472: p_payee_id IN iby_bepkeys.OwnerId%TYPE,
473: p_bepkey IN iby_bepkeys.KEY%TYPE,
474: p_instr_type IN iby_trxn_summaries_all.InstrType%TYPE,
475: px_bep_suffix_in_out IN OUT NOCOPY iby_bepinfo.Suffix%TYPE,
476: x_bepid_out OUT NOCOPY iby_bepinfo.BepId%TYPE,
477: x_bep_url_out OUT NOCOPY iby_bepinfo.BaseUrl%TYPE,
478: x_bep_pmtscheme_out OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,
479: x_bep_username_out OUT NOCOPY iby_bepinfo.BEPUsername%TYPE,
480: x_bep_passwd_out OUT NOCOPY iby_bepinfo.BEPPassword%TYPE,

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

473: p_bepkey IN iby_bepkeys.KEY%TYPE,
474: p_instr_type IN iby_trxn_summaries_all.InstrType%TYPE,
475: px_bep_suffix_in_out IN OUT NOCOPY iby_bepinfo.Suffix%TYPE,
476: x_bepid_out OUT NOCOPY iby_bepinfo.BepId%TYPE,
477: x_bep_url_out OUT NOCOPY iby_bepinfo.BaseUrl%TYPE,
478: x_bep_pmtscheme_out OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,
479: x_bep_username_out OUT NOCOPY iby_bepinfo.BEPUsername%TYPE,
480: x_bep_passwd_out OUT NOCOPY iby_bepinfo.BEPPassword%TYPE,
481: x_security_out OUT NOCOPY NUMBER,

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

475: px_bep_suffix_in_out IN OUT NOCOPY iby_bepinfo.Suffix%TYPE,
476: x_bepid_out OUT NOCOPY iby_bepinfo.BepId%TYPE,
477: x_bep_url_out OUT NOCOPY iby_bepinfo.BaseUrl%TYPE,
478: x_bep_pmtscheme_out OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,
479: x_bep_username_out OUT NOCOPY iby_bepinfo.BEPUsername%TYPE,
480: x_bep_passwd_out OUT NOCOPY iby_bepinfo.BEPPassword%TYPE,
481: x_security_out OUT NOCOPY NUMBER,
482: x_setnoinit_flag_out OUT NOCOPY NUMBER,
483: x_bep_type_out OUT NOCOPY iby_bepinfo.Bep_Type%TYPE,

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

476: x_bepid_out OUT NOCOPY iby_bepinfo.BepId%TYPE,
477: x_bep_url_out OUT NOCOPY iby_bepinfo.BaseUrl%TYPE,
478: x_bep_pmtscheme_out OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,
479: x_bep_username_out OUT NOCOPY iby_bepinfo.BEPUsername%TYPE,
480: x_bep_passwd_out OUT NOCOPY iby_bepinfo.BEPPassword%TYPE,
481: x_security_out OUT NOCOPY NUMBER,
482: x_setnoinit_flag_out OUT NOCOPY NUMBER,
483: x_bep_type_out OUT NOCOPY iby_bepinfo.Bep_Type%TYPE,
484: x_bep_lang_out OUT NOCOPY VARCHAR2,

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

479: x_bep_username_out OUT NOCOPY iby_bepinfo.BEPUsername%TYPE,
480: x_bep_passwd_out OUT NOCOPY iby_bepinfo.BEPPassword%TYPE,
481: x_security_out OUT NOCOPY NUMBER,
482: x_setnoinit_flag_out OUT NOCOPY NUMBER,
483: x_bep_type_out OUT NOCOPY iby_bepinfo.Bep_Type%TYPE,
484: x_bep_lang_out OUT NOCOPY VARCHAR2,
485: x_lead_time_out OUT NOCOPY iby_bepinfo.leadtime%TYPE
486: )
487: IS

Line 485: x_lead_time_out OUT NOCOPY iby_bepinfo.leadtime%TYPE

481: x_security_out OUT NOCOPY NUMBER,
482: x_setnoinit_flag_out OUT NOCOPY NUMBER,
483: x_bep_type_out OUT NOCOPY iby_bepinfo.Bep_Type%TYPE,
484: x_bep_lang_out OUT NOCOPY VARCHAR2,
485: x_lead_time_out OUT NOCOPY iby_bepinfo.leadtime%TYPE
486: )
487: IS
488: l_op_type iby_trxn_summaries_all.reqtype%TYPE;
489: l_base_url IBY_BEPInfo.BaseURL%TYPE;

Line 489: l_base_url IBY_BEPInfo.BaseURL%TYPE;

485: x_lead_time_out OUT NOCOPY iby_bepinfo.leadtime%TYPE
486: )
487: IS
488: l_op_type iby_trxn_summaries_all.reqtype%TYPE;
489: l_base_url IBY_BEPInfo.BaseURL%TYPE;
490: l_key_count NUMBER;
491:
492: BEGIN
493: getBepBySuffix(px_bep_suffix_in_out,x_bepid_out,l_base_url,x_bep_pmtscheme_out,p_instr_type);

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

945:
946: /* Internal procedure that gets the bep configuration by */
947: /* bep suffix. */
948: PROCEDURE getBepBySuffix
949: (i_suffix IN IBY_BEPInfo.Suffix%TYPE,
950: o_bepid OUT NOCOPY IBY_BEPInfo.BEPID%TYPE,
951: o_bep_base_url OUT NOCOPY IBY_BEPInfo.BaseURL%TYPE,
952: o_pmtschemename OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,
953: i_instrtype IN iby_accttype.instrtype%type )

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

946: /* Internal procedure that gets the bep configuration by */
947: /* bep suffix. */
948: PROCEDURE getBepBySuffix
949: (i_suffix IN IBY_BEPInfo.Suffix%TYPE,
950: o_bepid OUT NOCOPY IBY_BEPInfo.BEPID%TYPE,
951: o_bep_base_url OUT NOCOPY IBY_BEPInfo.BaseURL%TYPE,
952: o_pmtschemename OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,
953: i_instrtype IN iby_accttype.instrtype%type )
954: IS

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

947: /* bep suffix. */
948: PROCEDURE getBepBySuffix
949: (i_suffix IN IBY_BEPInfo.Suffix%TYPE,
950: o_bepid OUT NOCOPY IBY_BEPInfo.BEPID%TYPE,
951: o_bep_base_url OUT NOCOPY IBY_BEPInfo.BaseURL%TYPE,
952: o_pmtschemename OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,
953: i_instrtype IN iby_accttype.instrtype%type )
954: IS
955:

Line 961: FROM iby_bepinfo

957:
958: -- Get bep info
959: SELECT bepid , baseurl
960: INTO o_bepid, o_bep_base_url
961: FROM iby_bepinfo
962: WHERE suffix = i_suffix;
963:
964: -- Get payment scheme name
965: getPmtSchemeName(o_bepid, i_instrtype, o_pmtschemename);

Line 970: -- Suffix not found in IBY_BEPINFO table

966:
967: EXCEPTION
968:
969: WHEN NO_DATA_FOUND THEN
970: -- Suffix not found in IBY_BEPINFO table
971: IF (o_bepid IS NULL) THEN
972: raise_application_error(-20000, 'IBY_20361#', FALSE);
973: END IF;
974:

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

1069:
1070: /* Procedure: getBEPLang
1071: * Function: fetch valid nlslang based on input lang
1072: */
1073: procedure getBEPLang(i_bepid IN iby_bepinfo.bepid%type,
1074: io_beplang IN OUT NOCOPY iby_beplangs.beplang%type)
1075: IS
1076: CURSOR c_getPreferred(ci_bepid iby_bepinfo.bepid%type) IS
1077: SELECT beplang

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

1072: */
1073: procedure getBEPLang(i_bepid IN iby_bepinfo.bepid%type,
1074: io_beplang IN OUT NOCOPY iby_beplangs.beplang%type)
1075: IS
1076: CURSOR c_getPreferred(ci_bepid iby_bepinfo.bepid%type) IS
1077: SELECT beplang
1078: FROM iby_BEPlangs
1079: WHERE BEPID = ci_bepid
1080: AND Preferred = 0

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

1122: * statement to specify the NLSLANG.
1123: */
1124: /* comment out for now */
1125: /*
1126: FUNCTION getNLSLang(i_bepid IN iby_bepinfo.bepid%type,
1127: i_beplang IN iby_beplangs.beplang%type) RETURN VARCHAR2 IS
1128: v_Lang iby_beplangs.beplang%type;
1129: BEGIN
1130: v_Lang := i_beplang;

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

1134: */
1135:
1136:
1137: -- Get payment scheme name for given bep based on instrtype
1138: PROCEDURE getPmtSchemeName(i_bepid IN iby_bepinfo.bepid%type,
1139: i_instrtype IN iby_accttype.instrtype%type,
1140: o_pmtschemename OUT NOCOPY
1141: iby_pmtschemes.pmtschemename%type)
1142: IS

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

1144: l_scheme_not_found BOOLEAN := TRUE;
1145: l_bankpay_bep VARCHAR2(10);
1146: l_trxn_bep VARCHAR2(10);
1147:
1148: CURSOR c_getPmtSchemeName(ci_bepid iby_bepinfo.bepid%type,
1149: ci_name1 iby_pmtschemes.pmtschemename%type,
1150: ci_name2 iby_pmtschemes.pmtschemename%type DEFAULT NULL,
1151: ci_name3 iby_pmtschemes.pmtschemename%type DEFAULT NULL)
1152: IS

Line 1154: FROM iby_pmtschemes p, iby_bepinfo b

1150: ci_name2 iby_pmtschemes.pmtschemename%type DEFAULT NULL,
1151: ci_name3 iby_pmtschemes.pmtschemename%type DEFAULT NULL)
1152: IS
1153: SELECT p.PmtSchemename
1154: FROM iby_pmtschemes p, iby_bepinfo b
1155: WHERE p.bepid = b.bepid
1156: AND b.bepid = ci_bepid
1157: AND p.PMTSCHEMENAME IN (ci_name1, ci_name2, ci_name3);
1158:

Line 1182: --FROM iby_bepinfo

1178: -- by now to point to an existing BEP
1179: --
1180: --SELECT suffix
1181: --INTO l_trxn_bep
1182: --FROM iby_bepinfo
1183: --WHERE (bepid=i_bepid);
1184: --l_scheme_not_found := l_trxn_bep <> NVL(l_bankpay_bep,'');
1185: --ELSE
1186: -- Change 'CREDITCARD' to 'SSL' and 'SET' for payment scheme

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

1212:
1213: END getPmtSchemeName;
1214:
1215:
1216: PROCEDURE getBepUrl(i_base_url IN iby_bepinfo.baseurl%type,
1217: i_payment_op IN VARCHAR2,
1218: i_pmtschemename IN iby_pmtschemes.pmtschemename%type,
1219: i_suffix IN iby_bepinfo.suffix%type,
1220: o_bep_url OUT NOCOPY VARCHAR2)

Line 1219: i_suffix IN iby_bepinfo.suffix%type,

1215:
1216: PROCEDURE getBepUrl(i_base_url IN iby_bepinfo.baseurl%type,
1217: i_payment_op IN VARCHAR2,
1218: i_pmtschemename IN iby_pmtschemes.pmtschemename%type,
1219: i_suffix IN iby_bepinfo.suffix%type,
1220: o_bep_url OUT NOCOPY VARCHAR2)
1221: IS
1222: BEGIN
1223: IF (i_pmtschemename = 'SSL' OR i_pmtschemename = 'PURCHASECARD' OR

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

1242: END getBepUrl;
1243:
1244: PROCEDURE getBepIdByPmtName(i_paymentmethodname IN VARCHAR2,
1245: i_payeeid IN iby_payee.payeeid%type,
1246: o_bepid OUT NOCOPY iby_bepinfo.bepid%type,
1247: o_bepkey OUT NOCOPY iby_bepkeys.key%type,
1248: o_fc_user_profile_code IN OUT NOCOPY VARCHAR2)
1249: IS
1250: CURSOR c_getBepIdByPmtName(ci_paymentmethodname VARCHAR2)

Line 1253: FROM iby_routinginfo r, iby_bepinfo b

1249: IS
1250: CURSOR c_getBepIdByPmtName(ci_paymentmethodname VARCHAR2)
1251: IS
1252: SELECT b.bepid, r.bepkey, r.fndcpt_user_profile_code
1253: FROM iby_routinginfo r, iby_bepinfo b
1254: WHERE r.paymentmethodname = ci_paymentmethodname
1255: AND r.configured = 1
1256: AND r.bepid = b.bepid;
1257:

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

1274: END getBepIdByPmtName;
1275:
1276: PROCEDURE getDefaultBepId(i_mpayeeid IN iby_payee.mpayeeid%type,
1277: i_payment_channel_code IN iby_trxn_summaries_all.payment_channel_code%type,
1278: o_bepid OUT NOCOPY iby_bepinfo.bepid%type,
1279: o_bepkey OUT NOCOPY iby_bepkeys.key%type,
1280: o_fndcpt_user_profile_code OUT NOCOPY
1281: IBY_FNDCPT_USER_CC_PF_VL.USER_CC_PROFILE_CODE%TYPE)
1282: IS

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

1288: IS
1289: SELECT a.bepid,
1290: c.key,
1291: a.fndcpt_user_profile_code
1292: FROM iby_default_bep a, iby_bepinfo b, iby_bepkeys c
1293: WHERE a.payment_channel_code = ci_payment_channel_code
1294: AND a.mpayeeid = ci_mpayeeid
1295: AND a.bepid = b.bepid
1296: AND UPPER(b.activeStatus) = 'Y'

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

1309:
1310: END getDefaultBepId;
1311:
1312:
1313: PROCEDURE getBepById(i_bepid IN iby_bepinfo.bepid%type,
1314: o_suffix OUT NOCOPY iby_bepinfo.suffix%type,
1315: o_baseurl OUT NOCOPY iby_bepinfo.baseurl%type,
1316: o_securityscheme OUT NOCOPY iby_bepinfo.securityscheme%type,
1317: o_bepusername OUT NOCOPY iby_bepinfo.bepusername%type,

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

1310: END getDefaultBepId;
1311:
1312:
1313: PROCEDURE getBepById(i_bepid IN iby_bepinfo.bepid%type,
1314: o_suffix OUT NOCOPY iby_bepinfo.suffix%type,
1315: o_baseurl OUT NOCOPY iby_bepinfo.baseurl%type,
1316: o_securityscheme OUT NOCOPY iby_bepinfo.securityscheme%type,
1317: o_bepusername OUT NOCOPY iby_bepinfo.bepusername%type,
1318: o_beppassword OUT NOCOPY iby_bepinfo.beppassword%type,

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

1311:
1312:
1313: PROCEDURE getBepById(i_bepid IN iby_bepinfo.bepid%type,
1314: o_suffix OUT NOCOPY iby_bepinfo.suffix%type,
1315: o_baseurl OUT NOCOPY iby_bepinfo.baseurl%type,
1316: o_securityscheme OUT NOCOPY iby_bepinfo.securityscheme%type,
1317: o_bepusername OUT NOCOPY iby_bepinfo.bepusername%type,
1318: o_beppassword OUT NOCOPY iby_bepinfo.beppassword%type,
1319: o_beptype OUT NOCOPY iby_bepinfo.bep_type%TYPE,

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

1312:
1313: PROCEDURE getBepById(i_bepid IN iby_bepinfo.bepid%type,
1314: o_suffix OUT NOCOPY iby_bepinfo.suffix%type,
1315: o_baseurl OUT NOCOPY iby_bepinfo.baseurl%type,
1316: o_securityscheme OUT NOCOPY iby_bepinfo.securityscheme%type,
1317: o_bepusername OUT NOCOPY iby_bepinfo.bepusername%type,
1318: o_beppassword OUT NOCOPY iby_bepinfo.beppassword%type,
1319: o_beptype OUT NOCOPY iby_bepinfo.bep_type%TYPE,
1320: o_leadtime OUT NOCOPY iby_bepinfo.leadtime%TYPE)

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

1313: PROCEDURE getBepById(i_bepid IN iby_bepinfo.bepid%type,
1314: o_suffix OUT NOCOPY iby_bepinfo.suffix%type,
1315: o_baseurl OUT NOCOPY iby_bepinfo.baseurl%type,
1316: o_securityscheme OUT NOCOPY iby_bepinfo.securityscheme%type,
1317: o_bepusername OUT NOCOPY iby_bepinfo.bepusername%type,
1318: o_beppassword OUT NOCOPY iby_bepinfo.beppassword%type,
1319: o_beptype OUT NOCOPY iby_bepinfo.bep_type%TYPE,
1320: o_leadtime OUT NOCOPY iby_bepinfo.leadtime%TYPE)
1321: IS

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

1314: o_suffix OUT NOCOPY iby_bepinfo.suffix%type,
1315: o_baseurl OUT NOCOPY iby_bepinfo.baseurl%type,
1316: o_securityscheme OUT NOCOPY iby_bepinfo.securityscheme%type,
1317: o_bepusername OUT NOCOPY iby_bepinfo.bepusername%type,
1318: o_beppassword OUT NOCOPY iby_bepinfo.beppassword%type,
1319: o_beptype OUT NOCOPY iby_bepinfo.bep_type%TYPE,
1320: o_leadtime OUT NOCOPY iby_bepinfo.leadtime%TYPE)
1321: IS
1322: CURSOR c_getBepById(ci_bepid iby_bepinfo.bepid%type)

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

1315: o_baseurl OUT NOCOPY iby_bepinfo.baseurl%type,
1316: o_securityscheme OUT NOCOPY iby_bepinfo.securityscheme%type,
1317: o_bepusername OUT NOCOPY iby_bepinfo.bepusername%type,
1318: o_beppassword OUT NOCOPY iby_bepinfo.beppassword%type,
1319: o_beptype OUT NOCOPY iby_bepinfo.bep_type%TYPE,
1320: o_leadtime OUT NOCOPY iby_bepinfo.leadtime%TYPE)
1321: IS
1322: CURSOR c_getBepById(ci_bepid iby_bepinfo.bepid%type)
1323: IS

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

1316: o_securityscheme OUT NOCOPY iby_bepinfo.securityscheme%type,
1317: o_bepusername OUT NOCOPY iby_bepinfo.bepusername%type,
1318: o_beppassword OUT NOCOPY iby_bepinfo.beppassword%type,
1319: o_beptype OUT NOCOPY iby_bepinfo.bep_type%TYPE,
1320: o_leadtime OUT NOCOPY iby_bepinfo.leadtime%TYPE)
1321: IS
1322: CURSOR c_getBepById(ci_bepid iby_bepinfo.bepid%type)
1323: IS
1324: SELECT suffix, baseurl, securityscheme, BEPUsername, BEPPassword, bep_type, leadtime

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

1318: o_beppassword OUT NOCOPY iby_bepinfo.beppassword%type,
1319: o_beptype OUT NOCOPY iby_bepinfo.bep_type%TYPE,
1320: o_leadtime OUT NOCOPY iby_bepinfo.leadtime%TYPE)
1321: IS
1322: CURSOR c_getBepById(ci_bepid iby_bepinfo.bepid%type)
1323: IS
1324: SELECT suffix, baseurl, securityscheme, BEPUsername, BEPPassword, bep_type, leadtime
1325: FROM iby_bepinfo
1326: WHERE bepid = ci_bepid;

Line 1325: FROM iby_bepinfo

1321: IS
1322: CURSOR c_getBepById(ci_bepid iby_bepinfo.bepid%type)
1323: IS
1324: SELECT suffix, baseurl, securityscheme, BEPUsername, BEPPassword, bep_type, leadtime
1325: FROM iby_bepinfo
1326: WHERE bepid = ci_bepid;
1327:
1328: BEGIN
1329: IF (i_bepid = -1) THEN