DBA Data[Home] [Help]

APPS.ZX_AR_POPULATE_PKG dependencies on ZX_REP_TRX_DETAIL_T

Line 460: FROM zx_rep_trx_detail_t

456: BILL_TO_PARTY_SITE_ID,
457: SHIP_TO_PARTY_ID,
458: SHIP_TO_PARTY_SITE_ID,
459: HISTORICAL_FLAG
460: FROM zx_rep_trx_detail_t
461: WHERE EXTRACT_SOURCE_LEDGER = 'AR'
462: AND request_id = c_request_id;
463: */
464:

Line 554: FROM zx_rep_trx_detail_t zx_dtl,

550: xla_head.period_name,
551: zx_dtl.actg_source_id,
552: zx_dtl.bank_account_id,
553: ZX_DTL.tax_determine_date--Bug 5622686
554: FROM zx_rep_trx_detail_t zx_dtl,
555: xla_transaction_entities xla_ent,
556: xla_events xla_event,
557: xla_ae_headers xla_head,
558: xla_ae_lines xla_line,

Line 680: FROM zx_rep_trx_detail_t zx_dtl

676: TO_CHAR(NULL), --xla_head.period_name,
677: ZX_DTL.ACTG_SOURCE_ID,
678: zx_dtl.bank_account_id,
679: ZX_DTL.tax_determine_date --Bug 5622686
680: FROM zx_rep_trx_detail_t zx_dtl
681: WHERE zx_dtl.request_id = c_request_id
682: AND zx_dtl.extract_source_ledger = 'AR'
683: AND ((zx_dtl.posted_date IS NULL) OR
684: (zx_dtl.posted_date IS NOT NULL AND zx_dtl.tax_line_id is NULL));

Line 780: FROM zx_rep_trx_detail_t zx_dtl,

776: xla_head.period_name,
777: zx_dtl.actg_source_id,
778: zx_dtl.bank_account_id,
779: ZX_DTL.tax_determine_date
780: FROM zx_rep_trx_detail_t zx_dtl,
781: xla_transaction_entities xla_ent,
782: xla_events xla_event,
783: xla_ae_headers xla_head,
784: xla_ae_lines xla_line,

Line 901: FROM zx_rep_trx_detail_t zx_dtl

897: TO_CHAR(NULL), --xla_head.period_name,
898: ZX_DTL.ACTG_SOURCE_ID,
899: zx_dtl.bank_account_id,
900: ZX_DTL.tax_determine_date
901: FROM zx_rep_trx_detail_t zx_dtl
902: WHERE zx_dtl.request_id = c_request_id
903: AND zx_dtl.extract_source_ledger = 'AR'
904: AND ((zx_dtl.posted_date IS NULL) OR
905: (zx_dtl.posted_date IS NOT NULL AND zx_dtl.tax_line_id is NULL));

Line 1353: -- Call to update additional information in zx_rep_trx_detail_t table --

1349: END LOOP; -- end loop of each extract line
1350:
1351: END IF;
1352:
1353: -- Call to update additional information in zx_rep_trx_detail_t table --
1354:
1355: UPDATE_REP_DETAIL_T(l_count);
1356:
1357: -- Call to insert accounting information in zx_rep_actg_ext_t table --

Line 3371: l_bill_to_party_id zx_rep_trx_detail_t.BILL_TO_PARTY_ID%TYPE;

3367: END convert_amounts;
3368:
3369: PROCEDURE EXTRACT_PARTY_INFO( i IN BINARY_INTEGER) IS
3370:
3371: l_bill_to_party_id zx_rep_trx_detail_t.BILL_TO_PARTY_ID%TYPE;
3372: l_bill_to_pty_site_id zx_rep_trx_detail_t.BILL_TO_PARTY_SITE_ID%TYPE;
3373: l_bill_to_ptp_id zx_rep_trx_detail_t.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;
3374: l_bill_to_stp_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
3375:

Line 3372: l_bill_to_pty_site_id zx_rep_trx_detail_t.BILL_TO_PARTY_SITE_ID%TYPE;

3368:
3369: PROCEDURE EXTRACT_PARTY_INFO( i IN BINARY_INTEGER) IS
3370:
3371: l_bill_to_party_id zx_rep_trx_detail_t.BILL_TO_PARTY_ID%TYPE;
3372: l_bill_to_pty_site_id zx_rep_trx_detail_t.BILL_TO_PARTY_SITE_ID%TYPE;
3373: l_bill_to_ptp_id zx_rep_trx_detail_t.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;
3374: l_bill_to_stp_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
3375:
3376: l_ship_to_party_id zx_rep_trx_detail_t.SHIP_TO_PARTY_ID%TYPE;

Line 3373: l_bill_to_ptp_id zx_rep_trx_detail_t.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;

3369: PROCEDURE EXTRACT_PARTY_INFO( i IN BINARY_INTEGER) IS
3370:
3371: l_bill_to_party_id zx_rep_trx_detail_t.BILL_TO_PARTY_ID%TYPE;
3372: l_bill_to_pty_site_id zx_rep_trx_detail_t.BILL_TO_PARTY_SITE_ID%TYPE;
3373: l_bill_to_ptp_id zx_rep_trx_detail_t.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;
3374: l_bill_to_stp_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
3375:
3376: l_ship_to_party_id zx_rep_trx_detail_t.SHIP_TO_PARTY_ID%TYPE;
3377: l_ship_to_pty_site_id zx_rep_trx_detail_t.SHIP_TO_PARTY_SITE_ID%TYPE;

Line 3374: l_bill_to_stp_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE;

3370:
3371: l_bill_to_party_id zx_rep_trx_detail_t.BILL_TO_PARTY_ID%TYPE;
3372: l_bill_to_pty_site_id zx_rep_trx_detail_t.BILL_TO_PARTY_SITE_ID%TYPE;
3373: l_bill_to_ptp_id zx_rep_trx_detail_t.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;
3374: l_bill_to_stp_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
3375:
3376: l_ship_to_party_id zx_rep_trx_detail_t.SHIP_TO_PARTY_ID%TYPE;
3377: l_ship_to_pty_site_id zx_rep_trx_detail_t.SHIP_TO_PARTY_SITE_ID%TYPE;
3378: l_ship_to_ptp_id zx_rep_trx_detail_t.SHIP_FROM_PARTY_TAX_PROF_ID%TYPE;

Line 3376: l_ship_to_party_id zx_rep_trx_detail_t.SHIP_TO_PARTY_ID%TYPE;

3372: l_bill_to_pty_site_id zx_rep_trx_detail_t.BILL_TO_PARTY_SITE_ID%TYPE;
3373: l_bill_to_ptp_id zx_rep_trx_detail_t.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;
3374: l_bill_to_stp_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
3375:
3376: l_ship_to_party_id zx_rep_trx_detail_t.SHIP_TO_PARTY_ID%TYPE;
3377: l_ship_to_pty_site_id zx_rep_trx_detail_t.SHIP_TO_PARTY_SITE_ID%TYPE;
3378: l_ship_to_ptp_id zx_rep_trx_detail_t.SHIP_FROM_PARTY_TAX_PROF_ID%TYPE;
3379: l_ship_to_stp_id zx_rep_trx_detail_t.SHIP_FROM_SITE_TAX_PROF_ID%TYPE;
3380:

Line 3377: l_ship_to_pty_site_id zx_rep_trx_detail_t.SHIP_TO_PARTY_SITE_ID%TYPE;

3373: l_bill_to_ptp_id zx_rep_trx_detail_t.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;
3374: l_bill_to_stp_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
3375:
3376: l_ship_to_party_id zx_rep_trx_detail_t.SHIP_TO_PARTY_ID%TYPE;
3377: l_ship_to_pty_site_id zx_rep_trx_detail_t.SHIP_TO_PARTY_SITE_ID%TYPE;
3378: l_ship_to_ptp_id zx_rep_trx_detail_t.SHIP_FROM_PARTY_TAX_PROF_ID%TYPE;
3379: l_ship_to_stp_id zx_rep_trx_detail_t.SHIP_FROM_SITE_TAX_PROF_ID%TYPE;
3380:
3381: l_bill_to_acct_id zx_rep_trx_detail_t.BILL_TO_PARTY_ID%TYPE;

Line 3378: l_ship_to_ptp_id zx_rep_trx_detail_t.SHIP_FROM_PARTY_TAX_PROF_ID%TYPE;

3374: l_bill_to_stp_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
3375:
3376: l_ship_to_party_id zx_rep_trx_detail_t.SHIP_TO_PARTY_ID%TYPE;
3377: l_ship_to_pty_site_id zx_rep_trx_detail_t.SHIP_TO_PARTY_SITE_ID%TYPE;
3378: l_ship_to_ptp_id zx_rep_trx_detail_t.SHIP_FROM_PARTY_TAX_PROF_ID%TYPE;
3379: l_ship_to_stp_id zx_rep_trx_detail_t.SHIP_FROM_SITE_TAX_PROF_ID%TYPE;
3380:
3381: l_bill_to_acct_id zx_rep_trx_detail_t.BILL_TO_PARTY_ID%TYPE;
3382: l_bill_to_acct_site_id zx_rep_trx_detail_t.BILL_TO_PARTY_SITE_ID%TYPE;

Line 3379: l_ship_to_stp_id zx_rep_trx_detail_t.SHIP_FROM_SITE_TAX_PROF_ID%TYPE;

3375:
3376: l_ship_to_party_id zx_rep_trx_detail_t.SHIP_TO_PARTY_ID%TYPE;
3377: l_ship_to_pty_site_id zx_rep_trx_detail_t.SHIP_TO_PARTY_SITE_ID%TYPE;
3378: l_ship_to_ptp_id zx_rep_trx_detail_t.SHIP_FROM_PARTY_TAX_PROF_ID%TYPE;
3379: l_ship_to_stp_id zx_rep_trx_detail_t.SHIP_FROM_SITE_TAX_PROF_ID%TYPE;
3380:
3381: l_bill_to_acct_id zx_rep_trx_detail_t.BILL_TO_PARTY_ID%TYPE;
3382: l_bill_to_acct_site_id zx_rep_trx_detail_t.BILL_TO_PARTY_SITE_ID%TYPE;
3383:

Line 3381: l_bill_to_acct_id zx_rep_trx_detail_t.BILL_TO_PARTY_ID%TYPE;

3377: l_ship_to_pty_site_id zx_rep_trx_detail_t.SHIP_TO_PARTY_SITE_ID%TYPE;
3378: l_ship_to_ptp_id zx_rep_trx_detail_t.SHIP_FROM_PARTY_TAX_PROF_ID%TYPE;
3379: l_ship_to_stp_id zx_rep_trx_detail_t.SHIP_FROM_SITE_TAX_PROF_ID%TYPE;
3380:
3381: l_bill_to_acct_id zx_rep_trx_detail_t.BILL_TO_PARTY_ID%TYPE;
3382: l_bill_to_acct_site_id zx_rep_trx_detail_t.BILL_TO_PARTY_SITE_ID%TYPE;
3383:
3384: l_ship_to_acct_id zx_rep_trx_detail_t.SHIP_TO_PARTY_ID%TYPE;
3385: l_ship_to_acct_site_id zx_rep_trx_detail_t.SHIP_TO_PARTY_SITE_ID%TYPE;

Line 3382: l_bill_to_acct_site_id zx_rep_trx_detail_t.BILL_TO_PARTY_SITE_ID%TYPE;

3378: l_ship_to_ptp_id zx_rep_trx_detail_t.SHIP_FROM_PARTY_TAX_PROF_ID%TYPE;
3379: l_ship_to_stp_id zx_rep_trx_detail_t.SHIP_FROM_SITE_TAX_PROF_ID%TYPE;
3380:
3381: l_bill_to_acct_id zx_rep_trx_detail_t.BILL_TO_PARTY_ID%TYPE;
3382: l_bill_to_acct_site_id zx_rep_trx_detail_t.BILL_TO_PARTY_SITE_ID%TYPE;
3383:
3384: l_ship_to_acct_id zx_rep_trx_detail_t.SHIP_TO_PARTY_ID%TYPE;
3385: l_ship_to_acct_site_id zx_rep_trx_detail_t.SHIP_TO_PARTY_SITE_ID%TYPE;
3386:

Line 3384: l_ship_to_acct_id zx_rep_trx_detail_t.SHIP_TO_PARTY_ID%TYPE;

3380:
3381: l_bill_to_acct_id zx_rep_trx_detail_t.BILL_TO_PARTY_ID%TYPE;
3382: l_bill_to_acct_site_id zx_rep_trx_detail_t.BILL_TO_PARTY_SITE_ID%TYPE;
3383:
3384: l_ship_to_acct_id zx_rep_trx_detail_t.SHIP_TO_PARTY_ID%TYPE;
3385: l_ship_to_acct_site_id zx_rep_trx_detail_t.SHIP_TO_PARTY_SITE_ID%TYPE;
3386:
3387: l_bill_ship varchar2(30);
3388:

Line 3385: l_ship_to_acct_site_id zx_rep_trx_detail_t.SHIP_TO_PARTY_SITE_ID%TYPE;

3381: l_bill_to_acct_id zx_rep_trx_detail_t.BILL_TO_PARTY_ID%TYPE;
3382: l_bill_to_acct_site_id zx_rep_trx_detail_t.BILL_TO_PARTY_SITE_ID%TYPE;
3383:
3384: l_ship_to_acct_id zx_rep_trx_detail_t.SHIP_TO_PARTY_ID%TYPE;
3385: l_ship_to_acct_site_id zx_rep_trx_detail_t.SHIP_TO_PARTY_SITE_ID%TYPE;
3386:
3387: l_bill_ship varchar2(30);
3388:
3389: l_tbl_index_party BINARY_INTEGER;

Line 3409: CURSOR ledger_cur (c_ledger_id ZX_REP_TRX_DETAIL_T.ledger_id%TYPE) IS

3405: p_ret_record_level VARCHAR2(100);
3406: p_return_status VARCHAR2(100);
3407:
3408:
3409: CURSOR ledger_cur (c_ledger_id ZX_REP_TRX_DETAIL_T.ledger_id%TYPE) IS
3410: SELECT name
3411: FROM gl_ledgers
3412: WHERE ledger_id = c_ledger_id
3413: AND rownum = 1;

Line 3418: (c_party_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_ID%TYPE) IS

3414:
3415: -- If party_id is NOT NULL and Historical flag 'Y' then get the party tax profile ID from zx_party_tax_profile
3416:
3417: CURSOR party_reg_num_cur
3418: (c_party_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_ID%TYPE) IS
3419: SELECT rep_registration_number
3420: FROM zx_party_tax_profile
3421: WHERE party_id = c_party_id
3422: AND party_type_code = 'THIRD_PARTY';

Line 3425: (c_party_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_ID%TYPE) IS

3421: WHERE party_id = c_party_id
3422: AND party_type_code = 'THIRD_PARTY';
3423:
3424: CURSOR party_base_reg_num_cur
3425: (c_party_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_ID%TYPE) IS
3426: SELECT registration_number
3427: FROM zx_party_tax_profile ptp,
3428: zx_registrations reg
3429: WHERE ptp.party_id = c_party_id

Line 3435: (c_party_site_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_SITE_ID%TYPE) IS

3431: AND reg.party_tax_profile_id = ptp.party_tax_profile_id
3432: ORDER BY default_registration_flag DESC;
3433:
3434: CURSOR party_site_reg_cur
3435: (c_party_site_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_SITE_ID%TYPE) IS
3436: SELECT rep_registration_number
3437: FROM zx_party_tax_profile
3438: WHERE party_id = c_party_site_id
3439: AND party_type_code = 'THIRD_PARTY_SITE';

Line 3442: (c_party_site_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_SITE_ID%TYPE) IS

3438: WHERE party_id = c_party_site_id
3439: AND party_type_code = 'THIRD_PARTY_SITE';
3440:
3441: CURSOR party_site_base_reg_cur
3442: (c_party_site_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_SITE_ID%TYPE) IS
3443: SELECT registration_number
3444: FROM zx_party_tax_profile ptp,
3445: zx_registrations reg
3446: WHERE ptp.party_id = c_party_site_id

Line 3451: CURSOR party_cur (c_party_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_ID%TYPE) IS

3447: AND ptp.party_type_code = 'THIRD_PARTY_SITE'
3448: AND reg.party_tax_profile_id = ptp.party_tax_profile_id
3449: ORDER BY default_registration_flag DESC;
3450:
3451: CURSOR party_cur (c_party_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_ID%TYPE) IS
3452: select SUBSTRB(PARTY.PARTY_NAME,1,240) ,
3453: DECODE(PARTY.PARTY_TYPE,
3454: 'ORGANIZATION',
3455: PARTY.ORGANIZATION_NAME_PHONETIC,

Line 3466: CURSOR party_site_cur ( c_party_site_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_SITE_ID%TYPE) IS

3462: PARTY.JGZZ_FISCAL_CODE
3463: FROM HZ_PARTIES PARTY
3464: WHERE PARTY.PARTY_ID = c_party_id;
3465:
3466: CURSOR party_site_cur ( c_party_site_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_SITE_ID%TYPE) IS
3467: select LOC.CITY,
3468: LOC.COUNTY,
3469: LOC.STATE,
3470: LOC.PROVINCE,

Line 3482: CURSOR cust_acct_cur (c_site_use_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_SITE_ID%TYPE,

3478: HZ_LOCATIONS LOC
3479: WHERE party_site.party_site_id = c_party_site_id
3480: AND PARTY_SITE.LOCATION_ID = LOC.LOCATION_ID;
3481:
3482: CURSOR cust_acct_cur (c_site_use_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_SITE_ID%TYPE,
3483: c_cust_account_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_ID%TYPE,
3484: c_ship_bill varchar2) IS
3485: SELECT acct.account_number,
3486: acct.global_attribute10,

Line 3483: c_cust_account_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_ID%TYPE,

3479: WHERE party_site.party_site_id = c_party_site_id
3480: AND PARTY_SITE.LOCATION_ID = LOC.LOCATION_ID;
3481:
3482: CURSOR cust_acct_cur (c_site_use_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_SITE_ID%TYPE,
3483: c_cust_account_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_ID%TYPE,
3484: c_ship_bill varchar2) IS
3485: SELECT acct.account_number,
3486: acct.global_attribute10,
3487: acct.global_attribute12,

Line 3504: CURSOR bank_tp_taxpayer_cur (c_bank_account_id ZX_REP_TRX_DETAIL_T.BANK_ACCOUNT_ID%TYPE) IS

3500: and ACCT.CUST_ACCOUNT_ID = c_cust_account_id
3501: and site_use.site_use_code = c_ship_bill;
3502:
3503:
3504: CURSOR bank_tp_taxpayer_cur (c_bank_account_id ZX_REP_TRX_DETAIL_T.BANK_ACCOUNT_ID%TYPE) IS
3505: SELECT NVL(br_party.jgzz_fiscal_code, ba_party.jgzz_fiscal_code)
3506: FROM hz_parties br_party,
3507: hz_parties ba_party,
3508: ce_bank_branches_v ce_branch,

Line 3515: CURSOR doc_seq_name_cur (c_doc_seq_id ZX_REP_TRX_DETAIL_T.doc_seq_id%TYPE) IS

3511: AND ce_accts.bank_branch_id = ce_branch.branch_party_id
3512: AND ce_branch.branch_party_id = br_party.party_id
3513: AND ce_branch.bank_party_id = ba_party.party_id;
3514:
3515: CURSOR doc_seq_name_cur (c_doc_seq_id ZX_REP_TRX_DETAIL_T.doc_seq_id%TYPE) IS
3516: SELECT name
3517: FROM fnd_document_sequences
3518: WHERE doc_sequence_id = c_doc_seq_id;
3519:

Line 4379: UPDATE ZX_REP_TRX_DETAIL_T SET

4375: 'ZX_AR_POPULATE_PKG: UPDATE_REP_DETAIL_T(+)');
4376: END IF;
4377:
4378: FORALL i in 1..p_count
4379: UPDATE ZX_REP_TRX_DETAIL_T SET
4380: REP_CONTEXT_ID = G_REP_CONTEXT_ID,
4381: BILLING_TP_NUMBER = GT_BILLING_TP_NUMBER(i),
4382: BILLING_TP_TAX_REG_NUM = GT_BILLING_TP_TAX_REG_NUM(i),
4383: BILLING_TP_SITE_TAX_REG_NUM = GT_BILLING_SITE_TAX_REG_NUM(i),

Line 4482: | This procedure inserts payables tax data into ZX_REP_TRX_DETAIL_T table|

4478: /*===========================================================================+
4479: | PROCEDURE |
4480: | insert_actg_info |
4481: | DESCRIPTION |
4482: | This procedure inserts payables tax data into ZX_REP_TRX_DETAIL_T table|
4483: | |
4484: | SCOPE - Private |
4485: | |
4486: | NOTES |