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.PA_ADVERTISEMENTS_PVT dependencies on PA_ADVERTISEMENTS_PUB

Line 350: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;

346: l_action_line_audit_rec.action_code := p_action_code;
347: l_action_line_audit_rec.audit_display_attribute := NULL;
348: l_action_line_audit_rec.audit_attribute := NULL;
349: l_action_line_audit_rec.reversed_action_set_line_id := NULL;
350: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
351: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
352:
353: END IF;
354: -- 4537865 : Included Exception Block

Line 351: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;

347: l_action_line_audit_rec.audit_display_attribute := NULL;
348: l_action_line_audit_rec.audit_attribute := NULL;
349: l_action_line_audit_rec.reversed_action_set_line_id := NULL;
350: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
351: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
352:
353: END IF;
354: -- 4537865 : Included Exception Block
355: EXCEPTION

Line 460: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;

456: l_action_line_audit_rec.action_code := p_action_code;
457: l_action_line_audit_rec.audit_display_attribute := l_organization_name_tbl(i);
458: l_action_line_audit_rec.audit_attribute := l_organization_id_tbl(i);
459: l_action_line_audit_rec.reversed_action_set_line_id := NULL;
460: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
461: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
462: END LOOP;
463:
464: --dbms_output.put_line('number of records in audit global tbl: '||PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT);

Line 461: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;

457: l_action_line_audit_rec.audit_display_attribute := l_organization_name_tbl(i);
458: l_action_line_audit_rec.audit_attribute := l_organization_id_tbl(i);
459: l_action_line_audit_rec.reversed_action_set_line_id := NULL;
460: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
461: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
462: END LOOP;
463:
464: --dbms_output.put_line('number of records in audit global tbl: '||PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT);
465:

Line 464: --dbms_output.put_line('number of records in audit global tbl: '||PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT);

460: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
461: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
462: END LOOP;
463:
464: --dbms_output.put_line('number of records in audit global tbl: '||PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT);
465:
466: END IF; -- l_organization_id_tbl.count = 0
467:
468: -- Insert the error into the audit table

Line 481: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;

477:
478: l_action_line_audit_rec.reason_code := 'CONDITION_MET';
479: l_action_line_audit_rec.action_code := p_action_code;
480: l_action_line_audit_rec.encoded_error_message := l_encoded_message_text;
481: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
482: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
483: END IF;
484: x_return_status := FND_API.G_RET_STS_ERROR;
485: END IF; -- IF FND_MSG_PUB.Count_Msg > 0

Line 482: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;

478: l_action_line_audit_rec.reason_code := 'CONDITION_MET';
479: l_action_line_audit_rec.action_code := p_action_code;
480: l_action_line_audit_rec.encoded_error_message := l_encoded_message_text;
481: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
482: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
483: END IF;
484: x_return_status := FND_API.G_RET_STS_ERROR;
485: END IF; -- IF FND_MSG_PUB.Count_Msg > 0
486:

Line 672: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;

668: l_action_line_audit_rec.action_code := p_action_code;
669: l_action_line_audit_rec.audit_display_attribute := l_organization_name_tbl(i);
670: l_action_line_audit_rec.audit_attribute := l_organization_id_tbl(i);
671: l_action_line_audit_rec.reversed_action_set_line_id := NULL;
672: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
673: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
674: END LOOP;
675:
676: END IF; -- if l_organization_id_tbl.COUNT = 0

Line 673: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;

669: l_action_line_audit_rec.audit_display_attribute := l_organization_name_tbl(i);
670: l_action_line_audit_rec.audit_attribute := l_organization_id_tbl(i);
671: l_action_line_audit_rec.reversed_action_set_line_id := NULL;
672: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
673: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
674: END LOOP;
675:
676: END IF; -- if l_organization_id_tbl.COUNT = 0
677: END IF; --if l_new_start_org_id is null

Line 695: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;

691:
692: l_action_line_audit_rec.reason_code := 'CONDITION_MET';
693: l_action_line_audit_rec.action_code := p_action_code;
694: l_action_line_audit_rec.encoded_error_message := l_encoded_message_text;
695: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
696: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
697: END IF;
698: x_return_status := FND_API.G_RET_STS_ERROR;
699: END IF;

Line 696: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;

692: l_action_line_audit_rec.reason_code := 'CONDITION_MET';
693: l_action_line_audit_rec.action_code := p_action_code;
694: l_action_line_audit_rec.encoded_error_message := l_encoded_message_text;
695: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
696: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
697: END IF;
698: x_return_status := FND_API.G_RET_STS_ERROR;
699: END IF;
700:

Line 811: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;

807: l_action_line_audit_rec.action_code := p_action_code;
808: l_action_line_audit_rec.audit_display_attribute := l_person_name_tbl(i);
809: l_action_line_audit_rec.audit_attribute := l_person_id_tbl(i);
810: l_action_line_audit_rec.reversed_action_set_line_id := NULL;
811: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
812: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
813: END LOOP;
814:
815: END IF; -- if l_person_id_tbl.COUNT = 0

Line 812: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;

808: l_action_line_audit_rec.audit_display_attribute := l_person_name_tbl(i);
809: l_action_line_audit_rec.audit_attribute := l_person_id_tbl(i);
810: l_action_line_audit_rec.reversed_action_set_line_id := NULL;
811: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
812: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
813: END LOOP;
814:
815: END IF; -- if l_person_id_tbl.COUNT = 0
816:

Line 832: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;

828:
829: l_action_line_audit_rec.reason_code := 'CONDITION_MET';
830: l_action_line_audit_rec.action_code := p_action_code;
831: l_action_line_audit_rec.encoded_error_message := l_encoded_message_text;
832: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
833: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
834: END IF;
835: x_return_status := FND_API.G_RET_STS_ERROR;
836: END IF;

Line 833: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;

829: l_action_line_audit_rec.reason_code := 'CONDITION_MET';
830: l_action_line_audit_rec.action_code := p_action_code;
831: l_action_line_audit_rec.encoded_error_message := l_encoded_message_text;
832: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
833: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
834: END IF;
835: x_return_status := FND_API.G_RET_STS_ERROR;
836: END IF;
837:

Line 967: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;

963: l_action_line_audit_rec.audit_display_attribute := l_email_tab(j);--p_email_address added for 4701745;
964: l_action_line_audit_rec.audit_attribute := l_email_tab(j);--p_email_address added for 4701745;
965: l_action_line_audit_rec.reversed_action_set_line_id := NULL;
966:
967: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
968: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
969:
970: END IF;
971:

Line 968: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;

964: l_action_line_audit_rec.audit_attribute := l_email_tab(j);--p_email_address added for 4701745;
965: l_action_line_audit_rec.reversed_action_set_line_id := NULL;
966:
967: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
968: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
969:
970: END IF;
971:
972: END IF; -- l_email_tab(j) NOT NULL - added for 4701745

Line 1167: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;

1163: l_action_line_audit_rec.reason_code := 'UPDATED';
1164: ELSE
1165: l_action_line_audit_rec.reason_code := 'CONDITION_MET';
1166: END IF;
1167: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
1168: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
1169: END LOOP;
1170: END IF;
1171: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1168: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;

1164: ELSE
1165: l_action_line_audit_rec.reason_code := 'CONDITION_MET';
1166: END IF;
1167: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
1168: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
1169: END LOOP;
1170: END IF;
1171: x_return_status := FND_API.G_RET_STS_ERROR;
1172: END IF;

Line 1595: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;

1591: l_action_line_audit_rec.audit_display_attribute := p_ntf_recipient_name_tbl(i);
1592: l_action_line_audit_rec.audit_attribute := l_ntf_recipient_person_id_tbl(i);
1593: l_action_line_audit_rec.reversed_action_set_line_id := NULL;
1594:
1595: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
1596: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
1597:
1598: END IF;
1599:

Line 1596: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;

1592: l_action_line_audit_rec.audit_attribute := l_ntf_recipient_person_id_tbl(i);
1593: l_action_line_audit_rec.reversed_action_set_line_id := NULL;
1594:
1595: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
1596: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
1597:
1598: END IF;
1599:
1600: END IF; --if username is null

Line 1684: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;

1680: l_action_line_audit_rec.action_code := p_action_code;
1681: l_action_line_audit_rec.audit_display_attribute := l_staffing_priority_name;
1682: l_action_line_audit_rec.audit_attribute := p_staffing_priority_code;
1683: l_action_line_audit_rec.reversed_action_set_line_id := NULL;
1684: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
1685: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
1686:
1687: ELSE
1688:

Line 1685: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;

1681: l_action_line_audit_rec.audit_display_attribute := l_staffing_priority_name;
1682: l_action_line_audit_rec.audit_attribute := p_staffing_priority_code;
1683: l_action_line_audit_rec.reversed_action_set_line_id := NULL;
1684: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
1685: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
1686:
1687: ELSE
1688:
1689: -- ERROR: Insert error into the audit table

Line 1702: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;

1698:
1699: l_action_line_audit_rec.reason_code := 'CONDITION_MET';
1700: l_action_line_audit_rec.action_code := p_action_code;
1701: l_action_line_audit_rec.encoded_error_message := l_encoded_message_text;
1702: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
1703: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
1704: END IF; -- IF p_insert_audit_flag = 'T'
1705: x_return_status := FND_API.G_RET_STS_ERROR;
1706: END IF; -- IF FND_MSG_PUB.Count_Msg > 0

Line 1703: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;

1699: l_action_line_audit_rec.reason_code := 'CONDITION_MET';
1700: l_action_line_audit_rec.action_code := p_action_code;
1701: l_action_line_audit_rec.encoded_error_message := l_encoded_message_text;
1702: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
1703: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
1704: END IF; -- IF p_insert_audit_flag = 'T'
1705: x_return_status := FND_API.G_RET_STS_ERROR;
1706: END IF; -- IF FND_MSG_PUB.Count_Msg > 0
1707:

Line 1731: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;

1727: l_action_line_audit_rec.action_code := p_action_code;
1728: l_action_line_audit_rec.audit_display_attribute := l_update_sp_display_attribute;
1729: l_action_line_audit_rec.audit_attribute := p_staffing_priority_code;
1730: l_action_line_audit_rec.reversed_action_set_line_id := p_action_set_line_id;
1731: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
1732: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
1733:
1734: END IF;
1735:

Line 1732: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;

1728: l_action_line_audit_rec.audit_display_attribute := l_update_sp_display_attribute;
1729: l_action_line_audit_rec.audit_attribute := p_staffing_priority_code;
1730: l_action_line_audit_rec.reversed_action_set_line_id := p_action_set_line_id;
1731: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
1732: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
1733:
1734: END IF;
1735:
1736: END IF; -- action status

Line 1868: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;

1864: l_action_line_audit_rec.action_code := p_action_code;
1865: l_action_line_audit_rec.audit_display_attribute := null;
1866: l_action_line_audit_rec.audit_attribute := null;
1867: l_action_line_audit_rec.reversed_action_set_line_id := NULL;
1868: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
1869: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
1870:
1871: END IF;
1872:

Line 1869: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;

1865: l_action_line_audit_rec.audit_display_attribute := null;
1866: l_action_line_audit_rec.audit_attribute := null;
1867: l_action_line_audit_rec.reversed_action_set_line_id := NULL;
1868: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
1869: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
1870:
1871: END IF;
1872:
1873: -- get all the currently active audit lines

Line 1967: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;

1963: l_action_line_audit_rec.action_code := p_action_code;
1964: l_action_line_audit_rec.audit_display_attribute := l_remove_adv_display_attribute;
1965: l_action_line_audit_rec.audit_attribute := null;
1966: l_action_line_audit_rec.reversed_action_set_line_id := p_action_set_line_id;
1967: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
1968: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
1969:
1970: END IF;
1971:

Line 1968: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;

1964: l_action_line_audit_rec.audit_display_attribute := l_remove_adv_display_attribute;
1965: l_action_line_audit_rec.audit_attribute := null;
1966: l_action_line_audit_rec.reversed_action_set_line_id := p_action_set_line_id;
1967: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
1968: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
1969:
1970: END IF;
1971:
1972: IF l_action_set_line_id_tbl.COUNT > 0 THEN

Line 2205: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;

2201: ELSE
2202: l_action_line_audit_rec.reversed_action_set_line_id := NULL;
2203: END IF;
2204:
2205: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
2206: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
2207:
2208: ELSIF p_insert_audit_flag = 'T' AND l_perform_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2209:

Line 2206: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;

2202: l_action_line_audit_rec.reversed_action_set_line_id := NULL;
2203: END IF;
2204:
2205: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
2206: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
2207:
2208: ELSIF p_insert_audit_flag = 'T' AND l_perform_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2209:
2210: FND_MSG_PUB.get (

Line 2222: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;

2218: l_action_line_audit_rec.encoded_error_message := l_encoded_message_text;
2219: IF l_action_status_code = 'REVERSE_PENDING' THEN
2220: l_action_line_audit_rec.reversed_action_set_line_id := l_action_set_line_id_tbl(i);
2221: END IF;
2222: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
2223: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
2224:
2225: END IF; -- if p_insert_audit_flag = 'T'
2226:

Line 2223: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;

2219: IF l_action_status_code = 'REVERSE_PENDING' THEN
2220: l_action_line_audit_rec.reversed_action_set_line_id := l_action_set_line_id_tbl(i);
2221: END IF;
2222: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
2223: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
2224:
2225: END IF; -- if p_insert_audit_flag = 'T'
2226:
2227: END LOOP;