DBA Data[Home] [Help]

APPS.JAI_JAP_TY_TRIGGER_PKG dependencies on JAI_AP_TDS_CERT_NUMS_S

Line 102: ) VALUES ( JAI_AP_TDS_CERT_NUMS_S.nextval,

98: organization_id, legal_entity, fin_yr,
99: CERTIFICATE_NUM, LINE_NUM, Org_tan_num,
100: -- added, Harshita for Bug 4866533
101: created_by, creation_date, last_updated_by, last_update_date
102: ) VALUES ( JAI_AP_TDS_CERT_NUMS_S.nextval,
103: to_number(pr_new.Legal_Entity_Id), to_number(pr_new.Legal_Entity_Id), pr_new.Fin_Year,
104: NULL, NULL, pr_new.tan_no , --v_leg_org_tan_num, -- Harshita for Bug 4873356
105: -- added, Harshita for Bug 4866533
106: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate

Line 166: ) VALUES ( JAI_AP_TDS_CERT_NUMS_S.nextval,

162: organization_id, legal_entity, fin_yr,
163: CERTIFICATE_NUM, LINE_NUM, Org_tan_num,
164: -- added, Harshita for Bug 4866533
165: created_by, creation_date, last_updated_by, last_update_date
166: ) VALUES ( JAI_AP_TDS_CERT_NUMS_S.nextval,
167: c_org_id.Organization_id,
168: /* Bug 5388544. Added by Lakshmi Gopalsami
169: * Checked the value of legal_entity_id, If it is 0, insert the
170: * same else insert the value of c_org_id.organization_id.