DBA Data[Home] [Help]

APPS.IBY_FNDCPT_EXTRACT_GEN_PVT dependencies on IBY_FNDCPT_EXTRACT_GEN_PVT

Line 1: PACKAGE BODY IBY_FNDCPT_EXTRACT_GEN_PVT AS

1: PACKAGE BODY IBY_FNDCPT_EXTRACT_GEN_PVT AS
2: /* $Header: ibyfcxgb.pls 120.31.12010000.1 2008/07/28 05:40:44 appldev ship $ */
3:
4: G_DEBUG_MODULE CONSTANT VARCHAR2(100) := 'iby.plsql.IBY_FNDCPT_EXTRACT_GEN_PVT';
5:

Line 4: G_DEBUG_MODULE CONSTANT VARCHAR2(100) := 'iby.plsql.IBY_FNDCPT_EXTRACT_GEN_PVT';

1: PACKAGE BODY IBY_FNDCPT_EXTRACT_GEN_PVT AS
2: /* $Header: ibyfcxgb.pls 120.31.12010000.1 2008/07/28 05:40:44 appldev ship $ */
3:
4: G_DEBUG_MODULE CONSTANT VARCHAR2(100) := 'iby.plsql.IBY_FNDCPT_EXTRACT_GEN_PVT';
5:
6: G_SRA_DELIVERY_METHOD_ATTR CONSTANT NUMBER := 1;
7: G_SRA_EMAIL_ATTR CONSTANT NUMBER := 2;
8: G_SRA_FAX_ATTR CONSTANT NUMBER := 3;

Line 100: -- ||' and nvl(iby_fndcpt_extract_gen_pvt.Get_sra_Attribute(txn.trxnmid,1), ''x'') = nvl(:p_delivery_method, ''x'') ';

96: -- ||' and txn.reqdate <= nvl(to_date(:p_toDate, ''YYYY/MM/DD HH24:MI:SS''), SYSDATE) '
97: -- ||' and NVL(txn.mbatchid, -1) = NVL(:p_mbatchid, NVL(txn.mbatchid,-1)) '
98: -- ||' and txn.tangibleid >= NVL(:p_fromPSON, txn.tangibleid) '
99: -- ||' and txn.tangibleid <= NVL(:p_toPSON, txn.tangibleid) '
100: -- ||' and nvl(iby_fndcpt_extract_gen_pvt.Get_sra_Attribute(txn.trxnmid,1), ''x'') = nvl(:p_delivery_method, ''x'') ';
101:
102: -- from date is required program parameter
103: l_where_clause := l_where_clause || ' and txn.reqdate >= nvl(to_date( :p_fromDate, ''YYYY/MM/DD HH24:MI:SS''), SYSDATE) ';
104:

Line 124: l_where_clause := l_where_clause || ' and nvl(iby_fndcpt_extract_gen_pvt.Get_sra_Attribute(txn.trxnmid,1), ''x'') = nvl (:p_delivery_method, ''x'') ';

120: END IF;
121:
122: -- p_delivery_method must not be null
123: -- we don't create extract if p_delivery_method is null
124: l_where_clause := l_where_clause || ' and nvl(iby_fndcpt_extract_gen_pvt.Get_sra_Attribute(txn.trxnmid,1), ''x'') = nvl (:p_delivery_method, ''x'') ';
125:
126: -- p_format_code must not be null
127: -- we don't create extract if p_format_code is null
128: l_where_clause := l_where_clause || ' and iby_fndcpt_extract_gen_pvt.Get_sra_Attribute(txn.trxnmid, 7) = :p_format_code ';

Line 128: l_where_clause := l_where_clause || ' and iby_fndcpt_extract_gen_pvt.Get_sra_Attribute(txn.trxnmid, 7) = :p_format_code ';

124: l_where_clause := l_where_clause || ' and nvl(iby_fndcpt_extract_gen_pvt.Get_sra_Attribute(txn.trxnmid,1), ''x'') = nvl (:p_delivery_method, ''x'') ';
125:
126: -- p_format_code must not be null
127: -- we don't create extract if p_format_code is null
128: l_where_clause := l_where_clause || ' and iby_fndcpt_extract_gen_pvt.Get_sra_Attribute(txn.trxnmid, 7) = :p_format_code ';
129:
130: RETURN l_where_clause;
131:
132: END Get_Payer_Notif_Where_cluase;

Line 1150: END IBY_FNDCPT_EXTRACT_GEN_PVT;

1146: RETURN l_request_id;
1147:
1148: END submit_accompany_letter;
1149:
1150: END IBY_FNDCPT_EXTRACT_GEN_PVT;
1151: