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.AR_RECEIPT_LIB_PVT dependencies on DBMS_SQL

Line 6908: trx_customer := dbms_sql.open_cursor;

6904: IF p_installment IS NOT NULL THEN
6905: l_sel_stmt := l_sel_stmt || ' and ps.terms_sequence_number = :inst ';
6906: END IF;
6907:
6908: trx_customer := dbms_sql.open_cursor;
6909: dbms_sql.parse(trx_customer, l_sel_stmt, dbms_sql.v7);
6910: /* Bugfix 2605347 */
6911: dbms_sql.bind_variable(trx_customer,':pg_profile_enable_cc', pg_profile_enable_cc);
6912: dbms_sql.bind_variable(trx_customer,':p_currency_code', p_currency_code);

Line 6909: dbms_sql.parse(trx_customer, l_sel_stmt, dbms_sql.v7);

6905: l_sel_stmt := l_sel_stmt || ' and ps.terms_sequence_number = :inst ';
6906: END IF;
6907:
6908: trx_customer := dbms_sql.open_cursor;
6909: dbms_sql.parse(trx_customer, l_sel_stmt, dbms_sql.v7);
6910: /* Bugfix 2605347 */
6911: dbms_sql.bind_variable(trx_customer,':pg_profile_enable_cc', pg_profile_enable_cc);
6912: dbms_sql.bind_variable(trx_customer,':p_currency_code', p_currency_code);
6913: IF p_applied_payment_schedule_id IS NOT NULL THEN

Line 6911: dbms_sql.bind_variable(trx_customer,':pg_profile_enable_cc', pg_profile_enable_cc);

6907:
6908: trx_customer := dbms_sql.open_cursor;
6909: dbms_sql.parse(trx_customer, l_sel_stmt, dbms_sql.v7);
6910: /* Bugfix 2605347 */
6911: dbms_sql.bind_variable(trx_customer,':pg_profile_enable_cc', pg_profile_enable_cc);
6912: dbms_sql.bind_variable(trx_customer,':p_currency_code', p_currency_code);
6913: IF p_applied_payment_schedule_id IS NOT NULL THEN
6914: dbms_sql.bind_variable(trx_customer,':applied_ps_id',p_applied_payment_schedule_id);
6915: END IF;

Line 6912: dbms_sql.bind_variable(trx_customer,':p_currency_code', p_currency_code);

6908: trx_customer := dbms_sql.open_cursor;
6909: dbms_sql.parse(trx_customer, l_sel_stmt, dbms_sql.v7);
6910: /* Bugfix 2605347 */
6911: dbms_sql.bind_variable(trx_customer,':pg_profile_enable_cc', pg_profile_enable_cc);
6912: dbms_sql.bind_variable(trx_customer,':p_currency_code', p_currency_code);
6913: IF p_applied_payment_schedule_id IS NOT NULL THEN
6914: dbms_sql.bind_variable(trx_customer,':applied_ps_id',p_applied_payment_schedule_id);
6915: END IF;
6916: IF p_customer_trx_id IS NOT NULL THEN

Line 6914: dbms_sql.bind_variable(trx_customer,':applied_ps_id',p_applied_payment_schedule_id);

6910: /* Bugfix 2605347 */
6911: dbms_sql.bind_variable(trx_customer,':pg_profile_enable_cc', pg_profile_enable_cc);
6912: dbms_sql.bind_variable(trx_customer,':p_currency_code', p_currency_code);
6913: IF p_applied_payment_schedule_id IS NOT NULL THEN
6914: dbms_sql.bind_variable(trx_customer,':applied_ps_id',p_applied_payment_schedule_id);
6915: END IF;
6916: IF p_customer_trx_id IS NOT NULL THEN
6917: dbms_sql.bind_variable(trx_customer, ':cust_trx_id', p_customer_trx_id);
6918: END IF;

Line 6917: dbms_sql.bind_variable(trx_customer, ':cust_trx_id', p_customer_trx_id);

6913: IF p_applied_payment_schedule_id IS NOT NULL THEN
6914: dbms_sql.bind_variable(trx_customer,':applied_ps_id',p_applied_payment_schedule_id);
6915: END IF;
6916: IF p_customer_trx_id IS NOT NULL THEN
6917: dbms_sql.bind_variable(trx_customer, ':cust_trx_id', p_customer_trx_id);
6918: END IF;
6919: IF p_installment IS NOT NULL THEN
6920: dbms_sql.bind_variable(trx_customer, ':inst', p_installment);
6921: END IF;

Line 6920: dbms_sql.bind_variable(trx_customer, ':inst', p_installment);

6916: IF p_customer_trx_id IS NOT NULL THEN
6917: dbms_sql.bind_variable(trx_customer, ':cust_trx_id', p_customer_trx_id);
6918: END IF;
6919: IF p_installment IS NOT NULL THEN
6920: dbms_sql.bind_variable(trx_customer, ':inst', p_installment);
6921: END IF;
6922: dbms_sql.define_column(trx_customer,1,p_customer_id);
6923: dbms_sql.define_column(trx_customer,2,p_customer_site_use_id);
6924: -- End of bug 1907635

Line 6922: dbms_sql.define_column(trx_customer,1,p_customer_id);

6918: END IF;
6919: IF p_installment IS NOT NULL THEN
6920: dbms_sql.bind_variable(trx_customer, ':inst', p_installment);
6921: END IF;
6922: dbms_sql.define_column(trx_customer,1,p_customer_id);
6923: dbms_sql.define_column(trx_customer,2,p_customer_site_use_id);
6924: -- End of bug 1907635
6925:
6926: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6923: dbms_sql.define_column(trx_customer,2,p_customer_site_use_id);

6919: IF p_installment IS NOT NULL THEN
6920: dbms_sql.bind_variable(trx_customer, ':inst', p_installment);
6921: END IF;
6922: dbms_sql.define_column(trx_customer,1,p_customer_id);
6923: dbms_sql.define_column(trx_customer,2,p_customer_site_use_id);
6924: -- End of bug 1907635
6925:
6926: p_return_status := FND_API.G_RET_STS_SUCCESS;
6927: l_customer_trx_id := p_customer_trx_id;

Line 6939: l_rows_processed := dbms_sql.execute(trx_customer);

6935: IF p_applied_payment_schedule_id IS NOT NULL AND
6936: l_customer_trx_id IS NULL AND
6937: p_installment IS NULL THEN
6938: -- Bug 1907635
6939: l_rows_processed := dbms_sql.execute(trx_customer);
6940: IF dbms_sql.fetch_rows(trx_customer) > 0 then
6941: dbms_sql.column_value(trx_customer, 1, p_customer_id);
6942: dbms_sql.column_value(trx_customer, 2, p_customer_site_use_id);
6943: ELSE

Line 6940: IF dbms_sql.fetch_rows(trx_customer) > 0 then

6936: l_customer_trx_id IS NULL AND
6937: p_installment IS NULL THEN
6938: -- Bug 1907635
6939: l_rows_processed := dbms_sql.execute(trx_customer);
6940: IF dbms_sql.fetch_rows(trx_customer) > 0 then
6941: dbms_sql.column_value(trx_customer, 1, p_customer_id);
6942: dbms_sql.column_value(trx_customer, 2, p_customer_site_use_id);
6943: ELSE
6944: p_return_status := FND_API.G_RET_STS_ERROR;

Line 6941: dbms_sql.column_value(trx_customer, 1, p_customer_id);

6937: p_installment IS NULL THEN
6938: -- Bug 1907635
6939: l_rows_processed := dbms_sql.execute(trx_customer);
6940: IF dbms_sql.fetch_rows(trx_customer) > 0 then
6941: dbms_sql.column_value(trx_customer, 1, p_customer_id);
6942: dbms_sql.column_value(trx_customer, 2, p_customer_site_use_id);
6943: ELSE
6944: p_return_status := FND_API.G_RET_STS_ERROR;
6945: FND_MESSAGE.Set_Name( 'AR','AR_RAPI_PSID_NOT_DEF_CUS');

Line 6942: dbms_sql.column_value(trx_customer, 2, p_customer_site_use_id);

6938: -- Bug 1907635
6939: l_rows_processed := dbms_sql.execute(trx_customer);
6940: IF dbms_sql.fetch_rows(trx_customer) > 0 then
6941: dbms_sql.column_value(trx_customer, 1, p_customer_id);
6942: dbms_sql.column_value(trx_customer, 2, p_customer_site_use_id);
6943: ELSE
6944: p_return_status := FND_API.G_RET_STS_ERROR;
6945: FND_MESSAGE.Set_Name( 'AR','AR_RAPI_PSID_NOT_DEF_CUS');
6946: FND_MSG_PUB.Add;

Line 6948: dbms_sql.close_cursor(trx_customer);

6944: p_return_status := FND_API.G_RET_STS_ERROR;
6945: FND_MESSAGE.Set_Name( 'AR','AR_RAPI_PSID_NOT_DEF_CUS');
6946: FND_MSG_PUB.Add;
6947: END IF;
6948: dbms_sql.close_cursor(trx_customer);
6949: -- End Bug 1907635
6950: ELSIF p_applied_payment_schedule_id IS NOT NULL AND
6951: l_customer_trx_id IS NOT NULL AND
6952: p_installment IS NOT NULL THEN

Line 6954: l_rows_processed := dbms_sql.execute(trx_customer);

6950: ELSIF p_applied_payment_schedule_id IS NOT NULL AND
6951: l_customer_trx_id IS NOT NULL AND
6952: p_installment IS NOT NULL THEN
6953: -- Bug 1907635
6954: l_rows_processed := dbms_sql.execute(trx_customer);
6955: IF dbms_sql.fetch_rows(trx_customer) > 0 then
6956: dbms_sql.column_value(trx_customer, 1, p_customer_id);
6957: dbms_sql.column_value(trx_customer, 2, p_customer_site_use_id);
6958: ELSE

Line 6955: IF dbms_sql.fetch_rows(trx_customer) > 0 then

6951: l_customer_trx_id IS NOT NULL AND
6952: p_installment IS NOT NULL THEN
6953: -- Bug 1907635
6954: l_rows_processed := dbms_sql.execute(trx_customer);
6955: IF dbms_sql.fetch_rows(trx_customer) > 0 then
6956: dbms_sql.column_value(trx_customer, 1, p_customer_id);
6957: dbms_sql.column_value(trx_customer, 2, p_customer_site_use_id);
6958: ELSE
6959: p_return_status := FND_API.G_RET_STS_ERROR;

Line 6956: dbms_sql.column_value(trx_customer, 1, p_customer_id);

6952: p_installment IS NOT NULL THEN
6953: -- Bug 1907635
6954: l_rows_processed := dbms_sql.execute(trx_customer);
6955: IF dbms_sql.fetch_rows(trx_customer) > 0 then
6956: dbms_sql.column_value(trx_customer, 1, p_customer_id);
6957: dbms_sql.column_value(trx_customer, 2, p_customer_site_use_id);
6958: ELSE
6959: p_return_status := FND_API.G_RET_STS_ERROR;
6960: FND_MESSAGE.Set_Name( 'AR','AR_RAPI_TRX_INS_PS_NOT_DEF_CUS');

Line 6957: dbms_sql.column_value(trx_customer, 2, p_customer_site_use_id);

6953: -- Bug 1907635
6954: l_rows_processed := dbms_sql.execute(trx_customer);
6955: IF dbms_sql.fetch_rows(trx_customer) > 0 then
6956: dbms_sql.column_value(trx_customer, 1, p_customer_id);
6957: dbms_sql.column_value(trx_customer, 2, p_customer_site_use_id);
6958: ELSE
6959: p_return_status := FND_API.G_RET_STS_ERROR;
6960: FND_MESSAGE.Set_Name( 'AR','AR_RAPI_TRX_INS_PS_NOT_DEF_CUS');
6961: FND_MSG_PUB.Add;

Line 6963: dbms_sql.close_cursor(trx_customer);

6959: p_return_status := FND_API.G_RET_STS_ERROR;
6960: FND_MESSAGE.Set_Name( 'AR','AR_RAPI_TRX_INS_PS_NOT_DEF_CUS');
6961: FND_MSG_PUB.Add;
6962: END IF;
6963: dbms_sql.close_cursor(trx_customer);
6964: -- End Bug 1907635
6965: ELSIF p_applied_payment_schedule_id IS NOT NULL AND
6966: l_customer_trx_id IS NOT NULL AND
6967: p_installment IS NULL THEN

Line 6969: l_rows_processed := dbms_sql.execute(trx_customer);

6965: ELSIF p_applied_payment_schedule_id IS NOT NULL AND
6966: l_customer_trx_id IS NOT NULL AND
6967: p_installment IS NULL THEN
6968: -- Bug 1907635
6969: l_rows_processed := dbms_sql.execute(trx_customer);
6970: IF dbms_sql.fetch_rows(trx_customer) > 0 then
6971: dbms_sql.column_value(trx_customer, 1, p_customer_id);
6972: dbms_sql.column_value(trx_customer, 2, p_customer_site_use_id);
6973: ELSE

Line 6970: IF dbms_sql.fetch_rows(trx_customer) > 0 then

6966: l_customer_trx_id IS NOT NULL AND
6967: p_installment IS NULL THEN
6968: -- Bug 1907635
6969: l_rows_processed := dbms_sql.execute(trx_customer);
6970: IF dbms_sql.fetch_rows(trx_customer) > 0 then
6971: dbms_sql.column_value(trx_customer, 1, p_customer_id);
6972: dbms_sql.column_value(trx_customer, 2, p_customer_site_use_id);
6973: ELSE
6974: p_return_status := FND_API.G_RET_STS_ERROR;

Line 6971: dbms_sql.column_value(trx_customer, 1, p_customer_id);

6967: p_installment IS NULL THEN
6968: -- Bug 1907635
6969: l_rows_processed := dbms_sql.execute(trx_customer);
6970: IF dbms_sql.fetch_rows(trx_customer) > 0 then
6971: dbms_sql.column_value(trx_customer, 1, p_customer_id);
6972: dbms_sql.column_value(trx_customer, 2, p_customer_site_use_id);
6973: ELSE
6974: p_return_status := FND_API.G_RET_STS_ERROR;
6975: FND_MESSAGE.Set_Name( 'AR','AR_RAPI_TRX_PS_NOT_DEF_CUS');

Line 6972: dbms_sql.column_value(trx_customer, 2, p_customer_site_use_id);

6968: -- Bug 1907635
6969: l_rows_processed := dbms_sql.execute(trx_customer);
6970: IF dbms_sql.fetch_rows(trx_customer) > 0 then
6971: dbms_sql.column_value(trx_customer, 1, p_customer_id);
6972: dbms_sql.column_value(trx_customer, 2, p_customer_site_use_id);
6973: ELSE
6974: p_return_status := FND_API.G_RET_STS_ERROR;
6975: FND_MESSAGE.Set_Name( 'AR','AR_RAPI_TRX_PS_NOT_DEF_CUS');
6976: FND_MSG_PUB.Add;

Line 6978: dbms_sql.close_cursor(trx_customer);

6974: p_return_status := FND_API.G_RET_STS_ERROR;
6975: FND_MESSAGE.Set_Name( 'AR','AR_RAPI_TRX_PS_NOT_DEF_CUS');
6976: FND_MSG_PUB.Add;
6977: END IF;
6978: dbms_sql.close_cursor(trx_customer);
6979: -- End Bug 1907635
6980: ELSIF p_applied_payment_schedule_id IS NOT NULL AND
6981: l_customer_trx_id IS NULL AND
6982: p_installment IS NOT NULL THEN

Line 6984: l_rows_processed := dbms_sql.execute(trx_customer);

6980: ELSIF p_applied_payment_schedule_id IS NOT NULL AND
6981: l_customer_trx_id IS NULL AND
6982: p_installment IS NOT NULL THEN
6983: -- Bug 1907635
6984: l_rows_processed := dbms_sql.execute(trx_customer);
6985: IF dbms_sql.fetch_rows(trx_customer) > 0 then
6986: dbms_sql.column_value(trx_customer, 1, p_customer_id);
6987: dbms_sql.column_value(trx_customer, 2, p_customer_site_use_id);
6988: ELSE

Line 6985: IF dbms_sql.fetch_rows(trx_customer) > 0 then

6981: l_customer_trx_id IS NULL AND
6982: p_installment IS NOT NULL THEN
6983: -- Bug 1907635
6984: l_rows_processed := dbms_sql.execute(trx_customer);
6985: IF dbms_sql.fetch_rows(trx_customer) > 0 then
6986: dbms_sql.column_value(trx_customer, 1, p_customer_id);
6987: dbms_sql.column_value(trx_customer, 2, p_customer_site_use_id);
6988: ELSE
6989: p_return_status := FND_API.G_RET_STS_ERROR;

Line 6986: dbms_sql.column_value(trx_customer, 1, p_customer_id);

6982: p_installment IS NOT NULL THEN
6983: -- Bug 1907635
6984: l_rows_processed := dbms_sql.execute(trx_customer);
6985: IF dbms_sql.fetch_rows(trx_customer) > 0 then
6986: dbms_sql.column_value(trx_customer, 1, p_customer_id);
6987: dbms_sql.column_value(trx_customer, 2, p_customer_site_use_id);
6988: ELSE
6989: p_return_status := FND_API.G_RET_STS_ERROR;
6990: FND_MESSAGE.Set_Name( 'AR','AR_RAPI_INS_PS_NOT_DEF_CUS');

Line 6987: dbms_sql.column_value(trx_customer, 2, p_customer_site_use_id);

6983: -- Bug 1907635
6984: l_rows_processed := dbms_sql.execute(trx_customer);
6985: IF dbms_sql.fetch_rows(trx_customer) > 0 then
6986: dbms_sql.column_value(trx_customer, 1, p_customer_id);
6987: dbms_sql.column_value(trx_customer, 2, p_customer_site_use_id);
6988: ELSE
6989: p_return_status := FND_API.G_RET_STS_ERROR;
6990: FND_MESSAGE.Set_Name( 'AR','AR_RAPI_INS_PS_NOT_DEF_CUS');
6991: FND_MSG_PUB.Add;

Line 6993: dbms_sql.close_cursor(trx_customer);

6989: p_return_status := FND_API.G_RET_STS_ERROR;
6990: FND_MESSAGE.Set_Name( 'AR','AR_RAPI_INS_PS_NOT_DEF_CUS');
6991: FND_MSG_PUB.Add;
6992: END IF;
6993: dbms_sql.close_cursor(trx_customer);
6994: -- End Bug 1907635
6995: ELSIF p_applied_payment_schedule_id IS NULL AND
6996: l_customer_trx_id IS NOT NULL AND
6997: p_installment IS NOT NULL THEN

Line 6999: l_rows_processed := dbms_sql.execute(trx_customer);

6995: ELSIF p_applied_payment_schedule_id IS NULL AND
6996: l_customer_trx_id IS NOT NULL AND
6997: p_installment IS NOT NULL THEN
6998: -- Bug 1907635
6999: l_rows_processed := dbms_sql.execute(trx_customer);
7000: IF dbms_sql.fetch_rows(trx_customer) > 0 then
7001: dbms_sql.column_value(trx_customer, 1, p_customer_id);
7002: dbms_sql.column_value(trx_customer, 2, p_customer_site_use_id);
7003: ELSE

Line 7000: IF dbms_sql.fetch_rows(trx_customer) > 0 then

6996: l_customer_trx_id IS NOT NULL AND
6997: p_installment IS NOT NULL THEN
6998: -- Bug 1907635
6999: l_rows_processed := dbms_sql.execute(trx_customer);
7000: IF dbms_sql.fetch_rows(trx_customer) > 0 then
7001: dbms_sql.column_value(trx_customer, 1, p_customer_id);
7002: dbms_sql.column_value(trx_customer, 2, p_customer_site_use_id);
7003: ELSE
7004: p_return_status := FND_API.G_RET_STS_ERROR;

Line 7001: dbms_sql.column_value(trx_customer, 1, p_customer_id);

6997: p_installment IS NOT NULL THEN
6998: -- Bug 1907635
6999: l_rows_processed := dbms_sql.execute(trx_customer);
7000: IF dbms_sql.fetch_rows(trx_customer) > 0 then
7001: dbms_sql.column_value(trx_customer, 1, p_customer_id);
7002: dbms_sql.column_value(trx_customer, 2, p_customer_site_use_id);
7003: ELSE
7004: p_return_status := FND_API.G_RET_STS_ERROR;
7005: FND_MESSAGE.Set_Name( 'AR','AR_RAPI_TRX_INS_NOT_DEF_CUS');

Line 7002: dbms_sql.column_value(trx_customer, 2, p_customer_site_use_id);

6998: -- Bug 1907635
6999: l_rows_processed := dbms_sql.execute(trx_customer);
7000: IF dbms_sql.fetch_rows(trx_customer) > 0 then
7001: dbms_sql.column_value(trx_customer, 1, p_customer_id);
7002: dbms_sql.column_value(trx_customer, 2, p_customer_site_use_id);
7003: ELSE
7004: p_return_status := FND_API.G_RET_STS_ERROR;
7005: FND_MESSAGE.Set_Name( 'AR','AR_RAPI_TRX_INS_NOT_DEF_CUS');
7006: FND_MSG_PUB.Add;

Line 7008: dbms_sql.close_cursor(trx_customer);

7004: p_return_status := FND_API.G_RET_STS_ERROR;
7005: FND_MESSAGE.Set_Name( 'AR','AR_RAPI_TRX_INS_NOT_DEF_CUS');
7006: FND_MSG_PUB.Add;
7007: END IF;
7008: dbms_sql.close_cursor(trx_customer);
7009: -- End Bug 1907635
7010: ELSIF p_applied_payment_schedule_id IS NULL AND
7011: l_customer_trx_id IS NOT NULL AND
7012: p_installment IS NULL THEN

Line 7014: l_rows_processed := dbms_sql.execute(trx_customer);

7010: ELSIF p_applied_payment_schedule_id IS NULL AND
7011: l_customer_trx_id IS NOT NULL AND
7012: p_installment IS NULL THEN
7013: -- Bug 1907635
7014: l_rows_processed := dbms_sql.execute(trx_customer);
7015: IF dbms_sql.fetch_rows(trx_customer) > 0 then
7016: dbms_sql.column_value(trx_customer, 1, p_customer_id);
7017: dbms_sql.column_value(trx_customer, 2, p_customer_site_use_id);
7018: ELSE

Line 7015: IF dbms_sql.fetch_rows(trx_customer) > 0 then

7011: l_customer_trx_id IS NOT NULL AND
7012: p_installment IS NULL THEN
7013: -- Bug 1907635
7014: l_rows_processed := dbms_sql.execute(trx_customer);
7015: IF dbms_sql.fetch_rows(trx_customer) > 0 then
7016: dbms_sql.column_value(trx_customer, 1, p_customer_id);
7017: dbms_sql.column_value(trx_customer, 2, p_customer_site_use_id);
7018: ELSE
7019: p_return_status := FND_API.G_RET_STS_ERROR;

Line 7016: dbms_sql.column_value(trx_customer, 1, p_customer_id);

7012: p_installment IS NULL THEN
7013: -- Bug 1907635
7014: l_rows_processed := dbms_sql.execute(trx_customer);
7015: IF dbms_sql.fetch_rows(trx_customer) > 0 then
7016: dbms_sql.column_value(trx_customer, 1, p_customer_id);
7017: dbms_sql.column_value(trx_customer, 2, p_customer_site_use_id);
7018: ELSE
7019: p_return_status := FND_API.G_RET_STS_ERROR;
7020: FND_MESSAGE.Set_Name( 'AR','AR_RAPI_PSID_NOT_DEF_CUS');

Line 7017: dbms_sql.column_value(trx_customer, 2, p_customer_site_use_id);

7013: -- Bug 1907635
7014: l_rows_processed := dbms_sql.execute(trx_customer);
7015: IF dbms_sql.fetch_rows(trx_customer) > 0 then
7016: dbms_sql.column_value(trx_customer, 1, p_customer_id);
7017: dbms_sql.column_value(trx_customer, 2, p_customer_site_use_id);
7018: ELSE
7019: p_return_status := FND_API.G_RET_STS_ERROR;
7020: FND_MESSAGE.Set_Name( 'AR','AR_RAPI_PSID_NOT_DEF_CUS');
7021: FND_MSG_PUB.Add;

Line 7023: dbms_sql.close_cursor(trx_customer);

7019: p_return_status := FND_API.G_RET_STS_ERROR;
7020: FND_MESSAGE.Set_Name( 'AR','AR_RAPI_PSID_NOT_DEF_CUS');
7021: FND_MSG_PUB.Add;
7022: END IF;
7023: dbms_sql.close_cursor(trx_customer);
7024: -- End Bug 1907635
7025: ELSE
7026: -- Bug 1907635
7027: dbms_sql.close_cursor(trx_customer);

Line 7027: dbms_sql.close_cursor(trx_customer);

7023: dbms_sql.close_cursor(trx_customer);
7024: -- End Bug 1907635
7025: ELSE
7026: -- Bug 1907635
7027: dbms_sql.close_cursor(trx_customer);
7028: -- End Bug 1907635
7029: p_customer_id := NULL;
7030: p_customer_site_use_id := NULL;
7031: END IF;