eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POS_SUPP_CLASSIFICATION_PKG dependencies on POS_BUS_CLASS_ATTR

Line 29: insert into pos_bus_class_attr

25: x_status := 'S';
26:
27: if ( p_class_status = 'APPROVED' ) THEN
28:
29: insert into pos_bus_class_attr
30: (
31: classification_id, certificate_number,
32: certifying_agency, expiration_date,
33: class_status, status, created_by, creation_date,

Line 41: ( POS_BUS_CLASS_ATTR_S.NEXTVAL , p_cert_num,

37: party_id, lookup_type, lookup_code, start_date_active,
38: vendor_id
39: )
40: values
41: ( POS_BUS_CLASS_ATTR_S.NEXTVAL , p_cert_num,
42: p_cert_agency, p_exp_date,
43: 'APPROVED', 'A', fnd_global.user_id, sysdate,
44: p_ext_attr_1, null, null, null,
45: null, null, fnd_global.user_id,

Line 127: update pos_bus_class_attr

123: x_status := 'S';
124:
125: IF ( p_selected = 'N' ) then
126: if (p_classification_id is not null and p_classification_id > 0 ) then
127: update pos_bus_class_attr
128: set status='I', last_update_date = sysdate,
129: last_updated_by = fnd_global.user_id,
130: end_date_active = sysdate
131: where classification_id = p_classification_id;

Line 159: update pos_bus_class_attr

155: if ( p_class_status = 'APPROVED' ) then
156: -- Approved.
157: if (p_classification_id is not null and p_classification_id > 0 ) then
158: -- updating an already approved data
159: update pos_bus_class_attr
160: set certificate_number = p_cert_num,
161: certifying_agency = p_cert_agency,
162: expiration_date = p_exp_date,
163: class_status = 'APPROVED',

Line 182: select pos_bus_class_attr_s.nextval

178: last_update_date = sysdate
179: where bus_class_request_id = p_request_id;
180: end if;
181: else
182: select pos_bus_class_attr_s.nextval
183: into l_class_id
184: from dual;
185:
186: -- approving pending data

Line 187: insert into pos_bus_class_attr

183: into l_class_id
184: from dual;
185:
186: -- approving pending data
187: insert into pos_bus_class_attr
188: (
189: classification_id, certificate_number,
190: certifying_agency, expiration_date,
191: class_status, status, created_by, creation_date,

Line 223: update pos_bus_class_attr

219: if (p_classification_id is not null and p_classification_id > 0 ) then
220:
221: /* Not needed.
222:
223: update pos_bus_class_attr
224: set status='I', last_update_date = sysdate,
225: last_updated_by = fnd_global.user_id,
226: last_update_login = fnd_global.login_id
227: where classification_id = p_classification_id;*/

Line 353: FROM pos_bus_class_attr

349:
350: ELSIF(p_class_id_tbl(i) IS NOT NULL) THEN
351:
352: SELECT Max(classification_id) INTO l_class_id
353: FROM pos_bus_class_attr
354: WHERE party_id = p_party_id
355: AND lookup_type = p_lkp_type_tbl(i)
356: AND lookup_code = p_lkp_code_tbl(i)
357: AND ( end_date_active is null or trunc(end_date_active) > sysdate )

Line 384: FROM pos_bus_class_attr pca1

380: ELSE
381:
382: SELECT Count(*) INTO rec_count
383: FROM (SELECT lookup_code
384: FROM pos_bus_class_attr pca1
385: WHERE status = 'A'
386: AND ( pca1.end_date_active is null or trunc(pca1.end_date_active) > sysdate )
387: AND lookup_type = p_lkp_type_tbl(i)
388: AND lookup_code = p_lkp_code_tbl(i)

Line 462: from pos_bus_class_attr pca

458: -- if the Status is A then returns Y else return N
459: select decode(pca.status, 'A', 'Y', 'N')
460: , pca.last_update_date
461: into l_women_status, l_women_update_date
462: from pos_bus_class_attr pca
463: where pca.lookup_type='POS_BUSINESS_CLASSIFICATIONS'
464: and pca.lookup_code='WOMEN_OWNED'
465: and pca.start_date_active <= sysdate
466: and (pca.end_date_active is null or pca.end_date_active > sysdate)

Line 494: from pos_bus_class_attr pca

490: -- if the Status is A then returns Y else return N
491: select decode(pca.status, 'A', 'Y', 'N')
492: , pca.last_update_date
493: into l_small_business_status, l_small_buss_update_date
494: from pos_bus_class_attr pca
495: where pca.lookup_type='POS_BUSINESS_CLASSIFICATIONS'
496: and pca.lookup_code='SMALL_BUSINESS'
497: and pca.start_date_active <= sysdate
498: and (pca.end_date_active is null or pca.end_date_active > sysdate)

Line 526: from pos_bus_class_attr pca

522: select decode(pca.status, 'A', 'Y', 'N')
523: , pca.last_update_date, pca.ext_attr_1
524: into l_minority_status
525: , l_minority_update_date, l_minority_type
526: from pos_bus_class_attr pca
527: where pca.lookup_type='POS_BUSINESS_CLASSIFICATIONS'
528: and pca.lookup_code='MINORITY_OWNED'
529: and pca.start_date_active <= sysdate
530: and (pca.end_date_active is null or pca.end_date_active > sysdate)

Line 584: from pos_bus_class_attr pca

580: -- if the Status is A then returns Y else return N
581: pca.class_status
582: into l_pos_status, x_classification_id
583: ,l_approval_status
584: from pos_bus_class_attr pca
585: where pca.lookup_type=p_class_category
586: and pca.lookup_code=p_class_code
587: and pca.start_date_active <= sysdate
588: and (pca.end_date_active is null or pca.end_date_active > sysdate)

Line 603: select POS_BUS_CLASS_ATTR_S.NEXTVAL

599:
600: if ( l_po_status <> l_pos_status ) then
601: if( l_po_status = 'Y' ) then
602: x_modified := 'Y';
603: select POS_BUS_CLASS_ATTR_S.NEXTVAL
604: into l_id
605: from dual;
606:
607: insert into pos_bus_class_attr

Line 607: insert into pos_bus_class_attr

603: select POS_BUS_CLASS_ATTR_S.NEXTVAL
604: into l_id
605: from dual;
606:
607: insert into pos_bus_class_attr
608: (
609: classification_id, certificate_number,
610: certifying_agency, expiration_date,
611: class_status, status, created_by, creation_date,

Line 629: update pos_bus_class_attr

625: x_modified := 'Y';
626: -- end date the record only if the classification is approved,
627: -- if not it might simply be in pending stage, which shouldn not
628: -- be disturbed.
629: update pos_bus_class_attr
630: set status='I' , end_date_active = sysdate
631: where classification_id = x_classification_id;
632: END IF;
633: end if;

Line 637: update pos_bus_class_attr

633: end if;
634: else
635: if(l_approval_status <> 'APPROVED' ) then
636: x_modified := 'Y';
637: update pos_bus_class_attr
638: set class_status = 'APPROVED'
639: where classification_id = x_classification_id;
640: end if;
641: end if;

Line 721: update pos_bus_class_attr

717: l_classification_id
718: );
719:
720: if(l_classification_id is not null ) then
721: update pos_bus_class_attr
722: set ext_attr_1 = l_minority
723: where classification_id = l_classification_id;
724: end if;
725: else

Line 738: update pos_bus_class_attr

734: l_classification_id,
735: l_updated
736: );
737: if(l_classification_id is not null AND l_updated ='Y') then
738: update pos_bus_class_attr
739: set ext_attr_1 = l_minority
740: where classification_id = l_classification_id;
741: end if;
742: end if;

Line 749: update pos_bus_class_attr

745:
746: PROCEDURE remove_classification( pClassificationId in number)
747: IS
748: BEGIN
749: update pos_bus_class_attr
750: set status='I', last_update_date = sysdate,
751: last_updated_by = fnd_global.user_id,
752: end_date_active = sysdate
753: where classification_id = pClassificationId;

Line 779: insert into pos_bus_class_attr

775: BEGIN
776:
777: x_status := 'S';
778:
779: insert into pos_bus_class_attr
780: (
781: classification_id, certificate_number,
782: certifying_agency, expiration_date,
783: class_status, status, created_by, creation_date,

Line 791: ( POS_BUS_CLASS_ATTR_S.NEXTVAL , p_cert_num,

787: party_id, lookup_type, lookup_code, start_date_active,
788: vendor_id, party_site_id
789: )
790: values
791: ( POS_BUS_CLASS_ATTR_S.NEXTVAL , p_cert_num,
792: p_cert_agency, p_exp_date,
793: 'APPROVED', 'A', fnd_global.user_id, sysdate,
794: p_ext_attr_1, null, null, null,
795: null, null, fnd_global.user_id,

Line 832: update pos_bus_class_attr

828:
829: IF ( p_selected = 'N' ) then
830:
831: if (p_classification_id is not null and p_classification_id > 0 ) then
832: update pos_bus_class_attr
833: set status='I', last_update_date = sysdate,
834: last_updated_by = fnd_global.user_id,
835: end_date_active = sysdate
836: where classification_id = p_classification_id;

Line 847: update pos_bus_class_attr

843:
844: if (p_classification_id is not null and p_classification_id > 0 ) then
845:
846: -- updating an already approved data
847: update pos_bus_class_attr
848: set certificate_number = p_cert_num,
849: certifying_agency = p_cert_agency,
850: expiration_date = p_exp_date,
851: class_status = 'APPROVED',

Line 861: select pos_bus_class_attr_s.nextval

857: where classification_id = p_classification_id;
858:
859: else
860:
861: select pos_bus_class_attr_s.nextval
862: into l_class_id
863: from dual;
864:
865: -- approving pending data

Line 866: insert into pos_bus_class_attr

862: into l_class_id
863: from dual;
864:
865: -- approving pending data
866: insert into pos_bus_class_attr
867: (
868: classification_id, certificate_number,
869: certifying_agency, expiration_date,
870: class_status, status, created_by, creation_date,

Line 911: FROM pos_bus_class_attr

907: p_cert_agency VARCHAR2(100);
908:
909: CURSOR AddrBusClass IS
910: SELECT lookup_code, ext_attr_1, end_date_active, certificate_number, certifying_agency
911: FROM pos_bus_class_attr
912: WHERE vendor_id = p_vendor_id
913: AND party_site_id = p_party_site_id
914: AND vendor_site_id IS null
915: AND status = 'A';

Line 930: insert into pos_bus_class_attr

926:
927: FETCH AddrBusClass INTO p_lookup_code, p_ext_attr_1, p_exp_date, p_cert_num, p_cert_agency;
928: EXIT WHEN AddrBusClass%NOTFOUND;
929:
930: insert into pos_bus_class_attr
931: (
932: classification_id, certificate_number,
933: certifying_agency, expiration_date,
934: class_status, status, created_by, creation_date,

Line 943: POS_BUS_CLASS_ATTR_S.NEXTVAL , p_cert_num,

939: vendor_id, party_site_id, vendor_site_id
940: )
941: values
942: (
943: POS_BUS_CLASS_ATTR_S.NEXTVAL , p_cert_num,
944: p_cert_agency, p_exp_date,
945: 'APPROVED', 'A', fnd_global.user_id, sysdate,
946: p_ext_attr_1, null, null, null,
947: null, null, fnd_global.user_id,

Line 980: insert into pos_bus_class_attr

976: BEGIN
977:
978: x_status := 'S';
979:
980: insert into pos_bus_class_attr
981: (
982: classification_id, certificate_number,
983: certifying_agency, expiration_date,
984: class_status, status, created_by, creation_date,

Line 992: ( POS_BUS_CLASS_ATTR_S.NEXTVAL , p_cert_num,

988: party_id, lookup_type, lookup_code, start_date_active,
989: vendor_id, party_site_id, vendor_site_id
990: )
991: values
992: ( POS_BUS_CLASS_ATTR_S.NEXTVAL , p_cert_num,
993: p_cert_agency, p_exp_date,
994: 'APPROVED', 'A', fnd_global.user_id, sysdate,
995: p_ext_attr_1, null, null, null,
996: null, null, fnd_global.user_id,

Line 1034: update pos_bus_class_attr

1030:
1031: IF ( p_selected = 'N' ) then
1032:
1033: if (p_classification_id is not null and p_classification_id > 0 ) then
1034: update pos_bus_class_attr
1035: set status='I', last_update_date = sysdate,
1036: last_updated_by = fnd_global.user_id,
1037: end_date_active = sysdate
1038: where classification_id = p_classification_id;

Line 1049: update pos_bus_class_attr

1045:
1046: if (p_classification_id is not null and p_classification_id > 0 ) then
1047:
1048: -- updating an already approved data
1049: update pos_bus_class_attr
1050: set certificate_number = p_cert_num,
1051: certifying_agency = p_cert_agency,
1052: expiration_date = p_exp_date,
1053: class_status = 'APPROVED',

Line 1063: select pos_bus_class_attr_s.nextval

1059: where classification_id = p_classification_id;
1060:
1061: else
1062:
1063: select pos_bus_class_attr_s.nextval
1064: into l_class_id
1065: from dual;
1066:
1067: -- approving pending data

Line 1068: insert into pos_bus_class_attr

1064: into l_class_id
1065: from dual;
1066:
1067: -- approving pending data
1068: insert into pos_bus_class_attr
1069: (
1070: classification_id, certificate_number,
1071: certifying_agency, expiration_date,
1072: class_status, status, created_by, creation_date,