DBA Data[Home] [Help]

APPS.JE_INTERFACE_VAL dependencies on JG_GLOBE_FLEX_VAL_SHARED

Line 265: IF (NOT jg_globe_flex_val_shared.check_format(p_global_attribute1,'N',30,'','N','N','N','','')) then

261:
262: -- Taxable Amount
263: IF p_global_attribute1 is not null then
264: -- Bug 3510068. Changed the maximum size from 1 to 30.
265: IF (NOT jg_globe_flex_val_shared.check_format(p_global_attribute1,'N',30,'','N','N','N','','')) then
266: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
267: p_parent_id,
268: 'INVALID_GLOBAL_ATTR1',
269: p_default_last_updated_by,

Line 266: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

262: -- Taxable Amount
263: IF p_global_attribute1 is not null then
264: -- Bug 3510068. Changed the maximum size from 1 to 30.
265: IF (NOT jg_globe_flex_val_shared.check_format(p_global_attribute1,'N',30,'','N','N','N','','')) then
266: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
267: p_parent_id,
268: 'INVALID_GLOBAL_ATTR1',
269: p_default_last_updated_by,
270: p_default_last_update_login,

Line 286: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

282: (p_global_attribute17 is not null) or
283: (p_global_attribute18 is not null) or
284: (p_global_attribute19 is not null) THEN
285:
286: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
287: p_parent_id,
288: 'GLOBAL_ATTR_VALUE_FOUND',
289: p_default_last_updated_by,
290: p_default_last_update_login,

Line 358: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

354: (p_global_attribute19 IS NOT NULL) OR
355: (p_global_attribute20 IS NOT NULL))
356: THEN
357:
358: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
359: p_parent_id,
360: 'GLOBAL_ATTR_VALUE_FOUND',
361: p_default_last_updated_by,
362: p_default_last_update_login,

Line 412: jg_globe_flex_val_shared.insert_rejections(

408: IF (p_global_attribute2 IS NOT NULL AND
409: p_global_attribute2 NOT IN ('Y','N')) OR
410: (p_global_attribute2 IS NULL) THEN
411:
412: jg_globe_flex_val_shared.insert_rejections(
413: 'AP_INVOICES_INTERFACE',
414: p_parent_id,
415: 'INVALID_GLOBAL_ATTR2',
416: p_default_last_updated_by,

Line 445: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

441: (p_global_attribute18 IS NOT NULL) OR
442: (p_global_attribute19 IS NOT NULL) OR
443: (p_global_attribute20 IS NOT NULL))
444: THEN
445: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
446: p_parent_id,
447: 'GLOBAL_ATTR_VALUE_FOUND',
448: p_default_last_updated_by,
449: p_default_last_update_login,

Line 490: jg_globe_flex_val_shared.insert_rejections('AP_INVOICE_LINES_INTERFACE',

486: BEGIN
487: IF p_global_attribute2 IS NOT NULL THEN
488: if p_global_attribute3 is NULL THEN
489:
490: jg_globe_flex_val_shared.insert_rejections('AP_INVOICE_LINES_INTERFACE',
491: p_parent_id,
492: 'INVALID_GLOBAL_ATTR3',
493: p_default_last_updated_by,
494: p_default_last_update_login,

Line 503: jg_globe_flex_val_shared.insert_rejections('AP_INVOICE_LINES_INTERFACE',

499: end if;
500:
501: EXCEPTION
502: WHEN OTHERS THEN
503: jg_globe_flex_val_shared.insert_rejections('AP_INVOICE_LINES_INTERFACE',
504: p_parent_id,
505: 'GLOBAL_ATTR_VALUE_FOUND',
506: p_default_last_updated_by,
507: p_default_last_update_login,

Line 528: jg_globe_flex_val_shared.insert_rejections('AP_INVOICE_LINES_INTERFACE',

524: (p_global_attribute18 IS NOT NULL) or
525: (p_global_attribute19 IS NOT NULL) or
526: (p_global_attribute20 IS NOT NULL)
527: THEN
528: jg_globe_flex_val_shared.insert_rejections('AP_INVOICE_LINES_INTERFACE',
529: p_parent_id,
530: 'GLOBAL_ATTR_VALUE_FOUND',
531: p_default_last_updated_by,
532: p_default_last_update_login,

Line 544: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,

540: -- Modification to the passing of parameters to ar_business_rules for TCA model
541:
542: PROCEDURE ar_business_rules
543: (p_int_table_name IN VARCHAR2,
544: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
545: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
546: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
547: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
548: p_current_record_status OUT NOCOPY VARCHAR2) IS

Line 545: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,

541:
542: PROCEDURE ar_business_rules
543: (p_int_table_name IN VARCHAR2,
544: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
545: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
546: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
547: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
548: p_current_record_status OUT NOCOPY VARCHAR2) IS
549:

Line 546: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,

542: PROCEDURE ar_business_rules
543: (p_int_table_name IN VARCHAR2,
544: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
545: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
546: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
547: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
548: p_current_record_status OUT NOCOPY VARCHAR2) IS
549:
550: l_current_record_status VARCHAR2(1) := 'S';

Line 547: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,

543: (p_int_table_name IN VARCHAR2,
544: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
545: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
546: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
547: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
548: p_current_record_status OUT NOCOPY VARCHAR2) IS
549:
550: l_current_record_status VARCHAR2(1) := 'S';
551: l_ou_id NUMBER;

Line 602: ( p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,

598:
599:
600:
601: PROCEDURE je_gr_arxcudci_cust_txid
602: ( p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
603: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
604: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
605: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
606: p_record_status OUT NOCOPY VARCHAR2)

Line 603: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,

599:
600:
601: PROCEDURE je_gr_arxcudci_cust_txid
602: ( p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
603: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
604: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
605: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
606: p_record_status OUT NOCOPY VARCHAR2)
607: IS

Line 604: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,

600:
601: PROCEDURE je_gr_arxcudci_cust_txid
602: ( p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
603: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
604: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
605: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
606: p_record_status OUT NOCOPY VARCHAR2)
607: IS
608:

Line 605: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,

601: PROCEDURE je_gr_arxcudci_cust_txid
602: ( p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
603: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
604: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
605: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
606: p_record_status OUT NOCOPY VARCHAR2)
607: IS
608:
609: dummy_code NUMBER;

Line 636: jg_globe_flex_val_shared.update_interface_status

632: IF l_error_code IS NULL THEN
633: p_record_status := 'S';
634: ELSE
635: p_record_status := 'E';
636: jg_globe_flex_val_shared.update_interface_status
637: (l_row_id,
638: 'RA_CUSTOMERS_INTERFACE',
639: l_error_code,
640: p_record_status);

Line 648: ( p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,

644:
645:
646:
647: PROCEDURE je_zz_arxcudci_site_uses
648: ( p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
649: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
650: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
651: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
652: p_record_status OUT NOCOPY VARCHAR2)

Line 649: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,

645:
646:
647: PROCEDURE je_zz_arxcudci_site_uses
648: ( p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
649: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
650: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
651: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
652: p_record_status OUT NOCOPY VARCHAR2)
653: IS

Line 650: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,

646:
647: PROCEDURE je_zz_arxcudci_site_uses
648: ( p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
649: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
650: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
651: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
652: p_record_status OUT NOCOPY VARCHAR2)
653: IS
654:

Line 651: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,

647: PROCEDURE je_zz_arxcudci_site_uses
648: ( p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
649: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
650: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
651: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
652: p_record_status OUT NOCOPY VARCHAR2)
653: IS
654:
655: dummy_code NUMBER;

Line 682: jg_globe_flex_val_shared.update_interface_status

678: IF l_error_code IS NULL THEN
679: p_record_status := 'S';
680: ELSE
681: p_record_status := 'E';
682: jg_globe_flex_val_shared.update_interface_status
683: (l_row_id,
684: 'RA_CUSTOMERS_INTERFACE',
685: l_error_code,
686: p_record_status);