APPS.AR_BILLS_MAINTAIN_VAL_PVT dependencies on AR_TRANSACTION_HISTORY

Line 875: p_trh_rec IN ar_transaction_history%ROWTYPE)

871:
872:
873: PROCEDURE Validate_Accept_BR (
874: p_trx_rec IN ra_customer_trx%ROWTYPE,
875: p_trh_rec IN ar_transaction_history%ROWTYPE)
876: IS
877:
878: BEGIN
879:

Line 985: PROCEDURE Validate_Unpaid_BR (p_trh_rec IN ar_transaction_history%ROWTYPE ,

981: | |
982: +==============================================================================*/
983:
984:
985: PROCEDURE Validate_Unpaid_BR (p_trh_rec IN ar_transaction_history%ROWTYPE ,
986: p_unpaid_reason IN VARCHAR2 )
987: IS
988:
989: l_batch_rec AR_BATCHES%ROWTYPE;

Line 1043: p_trh_rec IN ar_transaction_history%ROWTYPE ,

1039:
1040:
1041: PROCEDURE Validate_Action_Dates ( p_trx_date IN DATE ,
1042: p_gl_date IN DATE ,
1043: p_trh_rec IN ar_transaction_history%ROWTYPE ,
1044: p_action IN VARCHAR2 )
1045:
1046: IS
1047:

Line 1128: p_trh_rec IN ar_transaction_history%ROWTYPE ,

1124: +==============================================================================*/
1125:
1126:
1127: PROCEDURE Validate_Remittance_Dates ( p_batch_rec IN ar_batches%ROWTYPE ,
1128: p_trh_rec IN ar_transaction_history%ROWTYPE ,
1129: p_trx_number IN ra_customer_trx.trx_number%TYPE )
1130:
1131: IS
1132:

Line 1133: l_trx_date ar_transaction_history.trx_date%type;

1129: p_trx_number IN ra_customer_trx.trx_number%TYPE )
1130:
1131: IS
1132:
1133: l_trx_date ar_transaction_history.trx_date%type;
1134: l_gl_date ar_transaction_history.gl_date%type;
1135:
1136: BEGIN
1137:

Line 1134: l_gl_date ar_transaction_history.gl_date%type;

1130:
1131: IS
1132:
1133: l_trx_date ar_transaction_history.trx_date%type;
1134: l_gl_date ar_transaction_history.gl_date%type;
1135:
1136: BEGIN
1137:
1138: IF PG_DEBUG in ('Y', 'C') THEN

Line 1144: FROM ar_transaction_history_all

1140: END IF;
1141: -- Bug9578330
1142: SELECT trx_date, gl_date
1143: INTO l_trx_date, l_gl_date
1144: FROM ar_transaction_history_all
1145: WHERE transaction_history_id = (SELECT MAX(transaction_history_id)
1146: FROM ar_transaction_history_all
1147: WHERE customer_trx_id = p_trh_rec.customer_trx_id
1148: AND event NOT IN (C_DESELECTED_REMITTANCE, C_SELECTED_REMITTANCE));

Line 1146: FROM ar_transaction_history_all

1142: SELECT trx_date, gl_date
1143: INTO l_trx_date, l_gl_date
1144: FROM ar_transaction_history_all
1145: WHERE transaction_history_id = (SELECT MAX(transaction_history_id)
1146: FROM ar_transaction_history_all
1147: WHERE customer_trx_id = p_trh_rec.customer_trx_id
1148: AND event NOT IN (C_DESELECTED_REMITTANCE, C_SELECTED_REMITTANCE));
1149:
1150: