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 292: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

288: (p_global_attribute18 is not null) or
289: (p_global_attribute19 is not null) or
290: (p_global_attribute20 is not null) THEN
291:
292: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
293: p_parent_id,
294: 'GLOBAL_ATTR_VALUE_FOUND',
295: p_default_last_updated_by,
296: p_default_last_update_login,

Line 364: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

360: (p_global_attribute19 IS NOT NULL) OR
361: (p_global_attribute20 IS NOT NULL))
362: THEN
363:
364: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
365: p_parent_id,
366: 'GLOBAL_ATTR_VALUE_FOUND',
367: p_default_last_updated_by,
368: p_default_last_update_login,

Line 418: jg_globe_flex_val_shared.insert_rejections(

414: IF (p_global_attribute2 IS NOT NULL AND
415: p_global_attribute2 NOT IN ('Y','N')) OR
416: (p_global_attribute2 IS NULL) THEN
417:
418: jg_globe_flex_val_shared.insert_rejections(
419: 'AP_INVOICES_INTERFACE',
420: p_parent_id,
421: 'INVALID_GLOBAL_ATTR2',
422: p_default_last_updated_by,

Line 451: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

447: (p_global_attribute18 IS NOT NULL) OR
448: (p_global_attribute19 IS NOT NULL) OR
449: (p_global_attribute20 IS NOT NULL))
450: THEN
451: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
452: p_parent_id,
453: 'GLOBAL_ATTR_VALUE_FOUND',
454: p_default_last_updated_by,
455: p_default_last_update_login,

Line 496: jg_globe_flex_val_shared.insert_rejections('AP_INVOICE_LINES_INTERFACE',

492: BEGIN
493: IF p_global_attribute2 IS NOT NULL THEN
494: if p_global_attribute3 is NULL THEN
495:
496: jg_globe_flex_val_shared.insert_rejections('AP_INVOICE_LINES_INTERFACE',
497: p_parent_id,
498: 'INVALID_GLOBAL_ATTR3',
499: p_default_last_updated_by,
500: p_default_last_update_login,

Line 509: jg_globe_flex_val_shared.insert_rejections('AP_INVOICE_LINES_INTERFACE',

505: end if;
506:
507: EXCEPTION
508: WHEN OTHERS THEN
509: jg_globe_flex_val_shared.insert_rejections('AP_INVOICE_LINES_INTERFACE',
510: p_parent_id,
511: 'GLOBAL_ATTR_VALUE_FOUND',
512: p_default_last_updated_by,
513: p_default_last_update_login,

Line 534: jg_globe_flex_val_shared.insert_rejections('AP_INVOICE_LINES_INTERFACE',

530: (p_global_attribute18 IS NOT NULL) or
531: (p_global_attribute19 IS NOT NULL) or
532: (p_global_attribute20 IS NOT NULL)
533: THEN
534: jg_globe_flex_val_shared.insert_rejections('AP_INVOICE_LINES_INTERFACE',
535: p_parent_id,
536: 'GLOBAL_ATTR_VALUE_FOUND',
537: p_default_last_updated_by,
538: p_default_last_update_login,

Line 550: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,

546: -- Modification to the passing of parameters to ar_business_rules for TCA model
547:
548: PROCEDURE ar_business_rules
549: (p_int_table_name IN VARCHAR2,
550: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
551: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
552: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
553: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
554: p_current_record_status OUT NOCOPY VARCHAR2) IS

Line 551: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,

547:
548: PROCEDURE ar_business_rules
549: (p_int_table_name IN VARCHAR2,
550: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
551: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
552: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
553: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
554: p_current_record_status OUT NOCOPY VARCHAR2) IS
555:

Line 552: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,

548: PROCEDURE ar_business_rules
549: (p_int_table_name IN VARCHAR2,
550: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
551: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
552: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
553: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
554: p_current_record_status OUT NOCOPY VARCHAR2) IS
555:
556: l_current_record_status VARCHAR2(1) := 'S';

Line 553: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,

549: (p_int_table_name IN VARCHAR2,
550: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
551: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
552: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
553: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
554: p_current_record_status OUT NOCOPY VARCHAR2) IS
555:
556: l_current_record_status VARCHAR2(1) := 'S';
557: l_ou_id NUMBER;

Line 608: ( p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,

604:
605:
606:
607: PROCEDURE je_gr_arxcudci_cust_txid
608: ( p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
609: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
610: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
611: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
612: p_record_status OUT NOCOPY VARCHAR2)

Line 609: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,

605:
606:
607: PROCEDURE je_gr_arxcudci_cust_txid
608: ( p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
609: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
610: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
611: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
612: p_record_status OUT NOCOPY VARCHAR2)
613: IS

Line 610: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,

606:
607: PROCEDURE je_gr_arxcudci_cust_txid
608: ( p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
609: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
610: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
611: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
612: p_record_status OUT NOCOPY VARCHAR2)
613: IS
614:

Line 611: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,

607: PROCEDURE je_gr_arxcudci_cust_txid
608: ( p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
609: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
610: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
611: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
612: p_record_status OUT NOCOPY VARCHAR2)
613: IS
614:
615: dummy_code NUMBER;

Line 642: jg_globe_flex_val_shared.update_interface_status

638: IF l_error_code IS NULL THEN
639: p_record_status := 'S';
640: ELSE
641: p_record_status := 'E';
642: jg_globe_flex_val_shared.update_interface_status
643: (l_row_id,
644: 'RA_CUSTOMERS_INTERFACE',
645: l_error_code,
646: p_record_status);

Line 654: ( p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,

650:
651:
652:
653: PROCEDURE je_zz_arxcudci_site_uses
654: ( p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
655: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
656: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
657: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
658: p_record_status OUT NOCOPY VARCHAR2)

Line 655: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,

651:
652:
653: PROCEDURE je_zz_arxcudci_site_uses
654: ( p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
655: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
656: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
657: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
658: p_record_status OUT NOCOPY VARCHAR2)
659: IS

Line 656: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,

652:
653: PROCEDURE je_zz_arxcudci_site_uses
654: ( p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
655: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
656: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
657: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
658: p_record_status OUT NOCOPY VARCHAR2)
659: IS
660:

Line 657: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,

653: PROCEDURE je_zz_arxcudci_site_uses
654: ( p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
655: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
656: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
657: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
658: p_record_status OUT NOCOPY VARCHAR2)
659: IS
660:
661: dummy_code NUMBER;

Line 688: jg_globe_flex_val_shared.update_interface_status

684: IF l_error_code IS NULL THEN
685: p_record_status := 'S';
686: ELSE
687: p_record_status := 'E';
688: jg_globe_flex_val_shared.update_interface_status
689: (l_row_id,
690: 'RA_CUSTOMERS_INTERFACE',
691: l_error_code,
692: p_record_status);