[Home] [Help]
215: p_token1_value => 'CURRENCY_CODE_FOR',
216: p_token2 => G_CHILD_TABLE_TOKEN,
217: p_token2_value => G_VIEW,
218: p_token3 => G_PARENT_TABLE_TOKEN,
219: p_token3_value => 'OKL_TRX_AR_INVOICES_V');
220:
221: RAISE G_EXCEPTION_HALT_VALIDATION;
222: END IF;
223:
314: p_token1_value => 'IBT_ID_FOR',
315: p_token2 => G_CHILD_TABLE_TOKEN,
316: p_token2_value => G_VIEW,
317: p_token3 => G_PARENT_TABLE_TOKEN,
318: p_token3_value => 'OKL_TRX_AR_INVOICES_V');
319:
320: RAISE G_EXCEPTION_HALT_VALIDATION;
321: END IF;
322:
375: p_token1_value => 'IXX_ID_FOR',
376: p_token2 => G_CHILD_TABLE_TOKEN,
377: p_token2_value => G_VIEW,
378: p_token3 => G_PARENT_TABLE_TOKEN,
379: p_token3_value => 'OKL_TRX_AR_INVOICES_V');
380:
381: RAISE G_EXCEPTION_HALT_VALIDATION;
382: END IF;
383:
414: p_token1_value => 'KHR_ID_FOR',
415: p_token2 => G_CHILD_TABLE_TOKEN,
416: p_token2_value => G_VIEW,
417: p_token3 => G_PARENT_TABLE_TOKEN,
418: p_token3_value => 'OKL_TRX_AR_INVOICES_V' );
419:
420: RAISE G_EXCEPTION_HALT_VALIDATION;
421: END IF;
422: END IF;
452: p_token1_value => 'IRM_ID_FOR',
453: p_token2 => G_CHILD_TABLE_TOKEN,
454: p_token2_value => G_VIEW,
455: p_token3 => G_PARENT_TABLE_TOKEN,
456: p_token3_value => 'OKL_TRX_AR_INVOICES_V' );
457:
458: RAISE G_EXCEPTION_HALT_VALIDATION;
459: END IF;
460: END IF;
491: p_token1_value => 'IRT_ID_FOR',
492: p_token2 => G_CHILD_TABLE_TOKEN,
493: p_token2_value => G_VIEW,
494: p_token3 => G_PARENT_TABLE_TOKEN,
495: p_token3_value => 'OKL_TRX_AR_INVOICES_V' );
496:
497: RAISE G_EXCEPTION_HALT_VALIDATION;
498: END IF;
499: END IF;
530: p_token1_value => 'CRA_ID_FOR',
531: p_token2 => G_CHILD_TABLE_TOKEN,
532: p_token2_value => G_VIEW,
533: p_token3 => G_PARENT_TABLE_TOKEN,
534: p_token3_value => 'OKL_TRX_AR_INVOICES_V' );
535:
536: RAISE G_EXCEPTION_HALT_VALIDATION;
537: END IF;
538: END IF;
571: p_token1_value => 'SVF_ID_FOR',
572: p_token2 => G_CHILD_TABLE_TOKEN,
573: p_token2_value => G_VIEW,
574: p_token3 => G_PARENT_TABLE_TOKEN,
575: p_token3_value => 'OKL_TRX_AR_INVOICES_V');
576:
577: RAISE G_EXCEPTION_HALT_VALIDATION;
578: END IF;
579:
609: p_token1_value => 'TAP_ID_FOR',
610: p_token2 => G_CHILD_TABLE_TOKEN,
611: p_token2_value => G_VIEW,
612: p_token3 => G_PARENT_TABLE_TOKEN,
613: p_token3_value => 'OKL_TRX_AR_INVOICES_V' );
614:
615: RAISE G_EXCEPTION_HALT_VALIDATION;
616: END IF;
617: END IF;
646: p_token1_value => 'QTE_ID_FOR',
647: p_token2 => G_CHILD_TABLE_TOKEN,
648: p_token2_value => G_VIEW,
649: p_token3 => G_PARENT_TABLE_TOKEN,
650: p_token3_value => 'OKL_TRX_AR_INVOICES_V' );
651:
652: RAISE G_EXCEPTION_HALT_VALIDATION;
653: END IF;
654: END IF;
683: p_token1_value => 'TCN_ID_FOR',
684: p_token2 => G_CHILD_TABLE_TOKEN,
685: p_token2_value => G_VIEW,
686: p_token3 => G_PARENT_TABLE_TOKEN,
687: p_token3_value => 'OKL_TRX_AR_INVOICES_V' );
688:
689: RAISE G_EXCEPTION_HALT_VALIDATION;
690: END IF;
691: END IF;
721: p_token1_value => 'TAI_ID_REVERSES_FOR',
722: p_token2 => G_CHILD_TABLE_TOKEN,
723: p_token2_value => G_VIEW,
724: p_token3 => G_PARENT_TABLE_TOKEN,
725: p_token3_value => 'OKL_TRX_AR_INVOICES_V' );
726:
727: RAISE G_EXCEPTION_HALT_VALIDATION;
728: END IF;
729: END IF;
758: p_token1_value => 'IPY_ID_FOR',
759: p_token2 => G_CHILD_TABLE_TOKEN,
760: p_token2_value => G_VIEW,
761: p_token3 => G_PARENT_TABLE_TOKEN,
762: p_token3_value => 'OKL_TRX_AR_INVOICES_V' );
763:
764: RAISE G_EXCEPTION_HALT_VALIDATION;
765: END IF;
766: END IF;
805: -- this cursor is performant. but the requirement here is to check for a transaction number
806: -- without any context. i.e. for the current operating unit
807: CURSOR l_trx_number_uniq_csr is
808: SELECT '1'
809: FROM OKL_TRX_AR_INVOICES_V INV
810: WHERE ID <> p_taiv_rec.id
811: AND TRX_NUMBER IS NOT NULL
812: AND TRX_NUMBER = p_taiv_rec.trx_number;
813:
861: p_token1_value => 'SET_OF_BOOKS_ID_FOR',
862: p_token2 => G_CHILD_TABLE_TOKEN,
863: p_token2_value => G_VIEW,
864: p_token3 => G_PARENT_TABLE_TOKEN,
865: p_token3_value => 'OKL_TRX_AR_INVOICES_V' );
866:
867: RAISE G_EXCEPTION_HALT_VALIDATION;
868: END IF;
869: END IF;
913: p_token1_value => 'TRY_ID_FOR',
914: p_token2 => G_CHILD_TABLE_TOKEN,
915: p_token2_value => G_VIEW,
916: p_token3 => G_PARENT_TABLE_TOKEN,
917: p_token3_value => 'OKL_TRX_AR_INVOICES_V' );
918:
919: RAISE G_EXCEPTION_HALT_VALIDATION;
920: END IF;
921: END IF;
1361: BEGIN
1362: RETURN(get_rec(p_okl_trx_ar_invoices_tl_rec, l_row_notfound));
1363: END get_rec;
1364: ---------------------------------------------------------------------------
1365: -- FUNCTION get_rec for: OKL_TRX_AR_INVOICES_V
1366: ---------------------------------------------------------------------------
1367: FUNCTION get_rec (
1368: p_taiv_rec IN taiv_rec_type,
1369: x_no_data_found OUT NOCOPY BOOLEAN
1450: -- end:30-Jan-07 cklee Billing R12 project
1451: --gkhuntet start 02-Nov-07
1452: TRANSACTION_DATE
1453: --gkhuntet end 02-Nov-07
1454: FROM Okl_Trx_Ar_Invoices_V
1455: WHERE okl_trx_ar_invoices_v.id = p_id;
1456: l_okl_taiv_pk okl_taiv_pk_csr%ROWTYPE;
1457: l_taiv_rec taiv_rec_type;
1458: BEGIN
1451: --gkhuntet start 02-Nov-07
1452: TRANSACTION_DATE
1453: --gkhuntet end 02-Nov-07
1454: FROM Okl_Trx_Ar_Invoices_V
1455: WHERE okl_trx_ar_invoices_v.id = p_id;
1456: l_okl_taiv_pk okl_taiv_pk_csr%ROWTYPE;
1457: l_taiv_rec taiv_rec_type;
1458: BEGIN
1459: x_no_data_found := TRUE;
1555: RETURN(get_rec(p_taiv_rec, l_row_notfound));
1556: END get_rec;
1557:
1558: -----------------------------------------------------------
1559: -- FUNCTION null_out_defaults for: OKL_TRX_AR_INVOICES_V --
1560: -----------------------------------------------------------
1561: FUNCTION null_out_defaults (
1562: p_taiv_rec IN taiv_rec_type
1563: ) RETURN taiv_rec_type IS
1885: ---------------------------------------------------------------------------
1886: -- PROCEDURE Validate_Attributes
1887: ---------------------------------------------------------------------------
1888: ---------------------------------------------------
1889: -- Validate_Attributes for:OKL_TRX_AR_INVOICES_V --
1890: ---------------------------------------------------
1891: FUNCTION Validate_Attributes (
1892: p_taiv_rec IN taiv_rec_type
1893: ) RETURN VARCHAR2 IS
2207: ---------------------------------------------------------------------------
2208: -- PROCEDURE Validate_Record
2209: ---------------------------------------------------------------------------
2210: -----------------------------------------------
2211: -- Validate_Record for:OKL_TRX_AR_INVOICES_V --
2212: -----------------------------------------------
2213: FUNCTION Validate_Record (
2214: p_taiv_rec IN taiv_rec_type
2215: ) RETURN VARCHAR2 IS
2431: ---------------------------------------------------------------------------
2432: -- PROCEDURE validate_row
2433: ---------------------------------------------------------------------------
2434: --------------------------------------------
2435: -- validate_row for:OKL_TRX_AR_INVOICES_V --
2436: --------------------------------------------
2437: PROCEDURE validate_row(
2438: p_api_version IN NUMBER,
2439: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
2974: '_PVT'
2975: );
2976: END insert_row;
2977: ------------------------------------------
2978: -- insert_row for:OKL_TRX_AR_INVOICES_V --
2979: ------------------------------------------
2980: PROCEDURE insert_row(
2981: p_api_version IN NUMBER,
2982: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
2994: l_tai_rec tai_rec_type;
2995: lx_tai_rec tai_rec_type;
2996: l_okl_trx_ar_invoices_tl_rec OklTrxArInvoicesTlRecType;
2997: lx_okl_trx_ar_invoices_tl_rec OklTrxArInvoicesTlRecType;
2998: l_legal_entity_id OKL_TRX_AR_INVOICES_V.legal_entity_id%TYPE; -- for LE Uptake project 08-11-2006
2999: -------------------------------
3000: -- FUNCTION fill_who_columns --
3001: -------------------------------
3002: FUNCTION fill_who_columns (
3011: l_taiv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
3012: RETURN(l_taiv_rec);
3013: END fill_who_columns;
3014: ----------------------------------------------
3015: -- Set_Attributes for:OKL_TRX_AR_INVOICES_V --
3016: ----------------------------------------------
3017: FUNCTION Set_Attributes (
3018: p_taiv_rec IN taiv_rec_type,
3019: x_taiv_rec OUT NOCOPY taiv_rec_type
3471: '_PVT'
3472: );
3473: END lock_row;
3474: ----------------------------------------
3475: -- lock_row for:OKL_TRX_AR_INVOICES_V --
3476: ----------------------------------------
3477: PROCEDURE lock_row(
3478: p_api_version IN NUMBER,
3479: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
4338: '_PVT'
4339: );
4340: END update_row;
4341: ------------------------------------------
4342: -- update_row for:OKL_TRX_AR_INVOICES_V --
4343: ------------------------------------------
4344: PROCEDURE update_row(
4345: p_api_version IN NUMBER,
4346: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
4718:
4719: RETURN(l_return_status);
4720: END populate_new_record;
4721: ----------------------------------------------
4722: -- Set_Attributes for:OKL_TRX_AR_INVOICES_V --
4723: ----------------------------------------------
4724: FUNCTION Set_Attributes (
4725: p_taiv_rec IN taiv_rec_type,
4726: x_taiv_rec OUT NOCOPY taiv_rec_type
5100: '_PVT'
5101: );
5102: END delete_row;
5103: ------------------------------------------
5104: -- delete_row for:OKL_TRX_AR_INVOICES_V --
5105: ------------------------------------------
5106: PROCEDURE delete_row(
5107: p_api_version IN NUMBER,
5108: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,