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 346: FROM pos_bus_class_attr

342:
343: ELSIF(p_class_id_tbl(i) IS NOT NULL) THEN
344:
345: SELECT Max(classification_id) INTO l_class_id
346: FROM pos_bus_class_attr
347: WHERE party_id = p_party_id
348: AND lookup_type = p_lkp_type_tbl(i)
349: AND lookup_code = p_lkp_code_tbl(i)
350: AND ( end_date_active is null or trunc(end_date_active) > sysdate )

Line 375: FROM pos_bus_class_attr pca1

371: ELSE
372:
373: SELECT Count(*) INTO rec_count
374: FROM (SELECT lookup_code
375: FROM pos_bus_class_attr pca1
376: WHERE status = 'A'
377: AND ( pca1.end_date_active is null or trunc(pca1.end_date_active) > sysdate )
378: AND lookup_type = p_lkp_type_tbl(i)
379: AND lookup_code = p_lkp_code_tbl(i)

Line 451: from pos_bus_class_attr pca

447: -- if the Status is A then returns Y else return N
448: select decode(pca.status, 'A', 'Y', 'N')
449: , pca.last_update_date
450: into l_women_status, l_women_update_date
451: from pos_bus_class_attr pca
452: where pca.lookup_type='POS_BUSINESS_CLASSIFICATIONS'
453: and pca.lookup_code='WOMEN_OWNED'
454: and pca.start_date_active <= sysdate
455: and (pca.end_date_active is null or pca.end_date_active > sysdate)

Line 481: from pos_bus_class_attr pca

477: -- if the Status is A then returns Y else return N
478: select decode(pca.status, 'A', 'Y', 'N')
479: , pca.last_update_date
480: into l_small_business_status, l_small_buss_update_date
481: from pos_bus_class_attr pca
482: where pca.lookup_type='POS_BUSINESS_CLASSIFICATIONS'
483: and pca.lookup_code='SMALL_BUSINESS'
484: and pca.start_date_active <= sysdate
485: and (pca.end_date_active is null or pca.end_date_active > sysdate)

Line 511: from pos_bus_class_attr pca

507: select decode(pca.status, 'A', 'Y', 'N')
508: , pca.last_update_date, pca.ext_attr_1
509: into l_minority_status
510: , l_minority_update_date, l_minority_type
511: from pos_bus_class_attr pca
512: where pca.lookup_type='POS_BUSINESS_CLASSIFICATIONS'
513: and pca.lookup_code='MINORITY_OWNED'
514: and pca.start_date_active <= sysdate
515: and (pca.end_date_active is null or pca.end_date_active > sysdate)

Line 567: from pos_bus_class_attr pca

563: -- if the Status is A then returns Y else return N
564: pca.class_status
565: into l_pos_status, x_classification_id
566: ,l_approval_status
567: from pos_bus_class_attr pca
568: where pca.lookup_type=p_class_category
569: and pca.lookup_code=p_class_code
570: and pca.start_date_active <= sysdate
571: and (pca.end_date_active is null or pca.end_date_active > sysdate)

Line 584: select POS_BUS_CLASS_ATTR_S.NEXTVAL

580:
581: if ( l_po_status <> l_pos_status ) then
582: if( l_po_status = 'Y' ) then
583: x_modified := 'Y';
584: select POS_BUS_CLASS_ATTR_S.NEXTVAL
585: into l_id
586: from dual;
587:
588: insert into pos_bus_class_attr

Line 588: insert into pos_bus_class_attr

584: select POS_BUS_CLASS_ATTR_S.NEXTVAL
585: into l_id
586: from dual;
587:
588: insert into pos_bus_class_attr
589: (
590: classification_id, certificate_number,
591: certifying_agency, expiration_date,
592: class_status, status, created_by, creation_date,

Line 610: update pos_bus_class_attr

606: x_modified := 'Y';
607: -- end date the record only if the classification is approved,
608: -- if not it might simply be in pending stage, which shouldn not
609: -- be disturbed.
610: update pos_bus_class_attr
611: set status='I' , end_date_active = sysdate
612: where classification_id = x_classification_id;
613: END IF;
614: end if;

Line 618: update pos_bus_class_attr

614: end if;
615: else
616: if(l_approval_status <> 'APPROVED' ) then
617: x_modified := 'Y';
618: update pos_bus_class_attr
619: set class_status = 'APPROVED'
620: where classification_id = x_classification_id;
621: end if;
622: end if;

Line 702: update pos_bus_class_attr

698: l_classification_id
699: );
700:
701: if(l_classification_id is not null ) then
702: update pos_bus_class_attr
703: set ext_attr_1 = l_minority
704: where classification_id = l_classification_id;
705: end if;
706: else

Line 719: update pos_bus_class_attr

715: l_classification_id,
716: l_updated
717: );
718: if(l_classification_id is not null AND l_updated ='Y') then
719: update pos_bus_class_attr
720: set ext_attr_1 = l_minority
721: where classification_id = l_classification_id;
722: end if;
723: end if;

Line 730: update pos_bus_class_attr

726:
727: PROCEDURE remove_classification( pClassificationId in number)
728: IS
729: BEGIN
730: update pos_bus_class_attr
731: set status='I', last_update_date = sysdate,
732: last_updated_by = fnd_global.user_id,
733: end_date_active = sysdate
734: where classification_id = pClassificationId;