APPS.PAY_IP_UTILITY dependencies on PAY_PATCH_STATUS

Line 1483: ** in table pay_patch_status

1479:
1480: /**********************************************************************
1481: ** Name : check_patch_exists
1482: ** Purpose : This function checks for a given patch
1483: ** in table pay_patch_status
1484: **********************************************************************/
1485: FUNCTION check_patch_exists (p_patch_name IN VARCHAR2
1486: ,p_patch_status IN VARCHAR2
1487: ,p_appl_release IN VARCHAR2

Line 1504: FROM pay_patch_status

1500: pay_ip_startup_util.write_log('LOG','PAY_34016_IP_CALL_PROC',lv_func_name,NULL);
1501:
1502: SELECT status
1503: INTO lv_patch_status
1504: FROM pay_patch_status
1505: WHERE patch_name = p_patch_name
1506: AND status = nvl(p_patch_status,status)
1507: AND legislation_code = p_leg_code
1508: AND ((p_appl_release = nvl(application_release,p_appl_release)) OR

Line 1521: ** in table pay_patch_status

1517:
1518: /**********************************************************************
1519: ** Name : insert_patch_status
1520: ** Purpose : This procedure inserts a given patch
1521: ** in table pay_patch_status
1522: **********************************************************************/
1523: PROCEDURE insert_patch_status
1524: (p_patch_number IN VARCHAR2
1525: ,p_patch_name IN VARCHAR2

Line 1535: INSERT INTO pay_patch_status

1531: IS
1532:
1533: BEGIN
1534: hr_utility.set_location('Entering... pay_ip_utility.insert_patch',10);
1535: INSERT INTO pay_patch_status
1536: (ID,
1537: PATCH_NUMBER,
1538: PATCH_NAME,
1539: APPLIED_DATE,

Line 1546: (PAY_PATCH_STATUS_S.nextval,

1542: APPLICATION_RELEASE,
1543: LEGISLATION_CODE
1544: )
1545: VALUES
1546: (PAY_PATCH_STATUS_S.nextval,
1547: p_patch_number,
1548: p_patch_name,
1549: sysdate,
1550: p_patch_status,